Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Quick measures MoM / QoQ absolute values

Dear Community, 

 

hoping for your always helpful support on a potentially very simple issue :).

I am successfully working with the quick measure functions to build MoM and similar (YoY, QoQ) trends. The problem is that this function only shows the percentage increase / decrease of my vaules (I have very simple data).

 

Is there any way to see  the increase / decrease also in absolute numbers ? Which could be more relevant for me in most of cases?

 

Possibly using the same (or another) quick measure - I am not very familiar with building DAX formulas myself unluckily. 

 

Thank you very much!

Luca

 

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Thanks Zoe!

 

I managed to figure it out with a very easy fix to the DAX formula for the % variation quick measure - I simply removed the part which was calulating the %. Here below for reference.

 

Thanks for the support however!

Luca

 

VAR __PREV_QUARTER =
    CALCULATE(
        SUM('MCU_BaseLineData'[Column1.Forest_Area_Total__c]);
        DATEADD('MCU_AllDates'[Dates]; -1; QUARTER)
    )
RETURN
        SUM('MCU_BaseLineData'[Column1.Forest_Area_Total__c])- __PREV_QUARTER

View solution in original post

2 REPLIES 2
dax
Community Support
Community Support

Hi Chateaux83,

In your scenario, it seems that you want to get increase amount based on month or year, right? If so, you could try below expression to see whether it works or not

 

monthincrease =
IF (
    ISBLANK (
        CALCULATE (
            SUM ( monthincrease[amount] ),
            DATEADD ( monthincrease[month], -1, MONTH )
        )
    ),
    0,
    SUM ( monthincrease[amount] )
        - CALCULATE (
            SUM ( monthincrease[amount] ),
            DATEADD ( monthincrease[month], -1, MONTH )
        )
)

yearincrease =
IF (
    ISBLANK (
        CALCULATE (
            SUM ( monthincrease[amount] ),
            DATEADD ( monthincrease[month], -1, YEAR )
        )
    ),
    0,
    SUM ( monthincrease[amount] )
        - CALCULATE (
            SUM ( monthincrease[amount] ),
            DATEADD ( monthincrease[month], -1, YEAR )
        )
)

Capture12.PNG

Best Regards,
Zoe Zhi

Anonymous
Not applicable

Thanks Zoe!

 

I managed to figure it out with a very easy fix to the DAX formula for the % variation quick measure - I simply removed the part which was calulating the %. Here below for reference.

 

Thanks for the support however!

Luca

 

VAR __PREV_QUARTER =
    CALCULATE(
        SUM('MCU_BaseLineData'[Column1.Forest_Area_Total__c]);
        DATEADD('MCU_AllDates'[Dates]; -1; QUARTER)
    )
RETURN
        SUM('MCU_BaseLineData'[Column1.Forest_Area_Total__c])- __PREV_QUARTER

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.