We designed these with one purpose in mind: remove the customer pain point of having to learn DAX to use Power Pivot or Power BI with their QuickBooks data.
It would be impossible to anticipate every type of comparison, but there are enough present in each data model, such that a customer could replicate one without spending hours of research time.
We primarily provide two types of comparisons:
Most of these are used within financial related data models.
NOTE: Comparison such as Year-Over-Year (YOY) or Month-Over-Month (MOM) are included in the Calendar Pattern Measures 📅
Examples:
Compare Actual - Current MTD vs Previous Year MTD =VAR ValuePlus = [Current Month-to-Date Actual]VAR ValueMinus = [Previous Year Month-to-Date Actual]VAR Result = IF ( NOT ISBLANK ( ValuePlus ) && NOT ISBLANK ( ValueMinus ), ValuePlus - ValueMinus )RETURN Result
Compare Actual - Current MTD vs. Previous Year MTD % =DIVIDE ( [Compare Actual - Current MTD vs Previous Year MTD], [Previous Year Month-to-Date Actual])
Please enable JavaScript to use file uploader.
is requesting access to a wiki that you have locked: https://clearify.com/wiki/view/6133/comparison-measures
Your session has expired. You are being logged out.