Forum Discussion
Need column level difference
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
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
MFelix thank you . works fine for me.