Forum Discussion
bhuprakashs
8 months agoHelper I
Need column level difference
Hi team, I need a column level difference to show in table metrix. current data: Column level I am using a Category from a table in table metrix. how to show difference between colum...
- 8 months ago
Hi bhuprakashs ,
If you are using a live connection this is a good option to use visual calculations:
Versus previous = [Total Value] - PREVIOUS([Total Value],COLUMNS)The total value is your measure:
If you don't want to show difference when the value is blank on the last column just redo to:
Versus previous = IF(ISBLANK([Total Value]), BLANK(), [Total Value] - PREVIOUS([Total Value],COLUMNS))Check the detail how to use visual calculations:
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-visual-calculations-overview
bhuprakashs
8 months agoHelper I
rohit1991 thanks for help but it is giving me same value. it is not giving me difference value