Forum Discussion
Presenting differences/variances in one table
Can you try with difference measure:
Difference =
VAR Wave1 = CALCULATE(SUM('Table'[Value]), 'Table'[Wave] = "Wave 1")
VAR Wave2 = CALCULATE(SUM('Table'[Value]), 'Table'[Wave] = "Wave 2")RETURN
IF(NOT(ISBLANK(Wave1)) && NOT(ISBLANK(Wave2)), Wave2 - Wave1, BLANK())
Hi rajendraongole1 ,
I am still seeing the value after using your new measure: Property A should be -121 and Property B should be +66 instead.
Can you try with difference measure:
Difference =
VAR Wave1 = CALCULATE(SUM('Table'[Value]), 'Table'[Wave] = "Wave 1")
VAR Wave2 = CALCULATE(SUM('Table'[Value]), 'Table'[Wave] = "Wave 2")RETURN
IF(NOT(ISBLANK(Wave1)) && NOT(ISBLANK(Wave2)), Wave2 - Wave1, BLANK())Hi lsihui_,
Thank you for reaching out to Microsoft Fabric Community.
Thank you rajendraongole1 for the prompt response.
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user resolved your issue? or let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.Thanks and regards,
Anjan Kumar Chippa
