Hi,
I created this measure to compare particular period vs period to see the gap.
it works okay when they both periods have the same row items and values but when only one period has the row, then it cannot work smartly.
e.g. 2Q P7 QTY is 480 but P8 is null(cuz P8 doesn't have that item at all), then it should have been -480 under Diff. total.
so any idea to change my measure pls?
and another one is Row total on top shoudn't have icon for P7/P8 value, only need the icons for column total(for gap),
but it seems there's no option to activate it only for row or column, right?
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
