Forum Discussion
bhuprakashs
Helper I
Helper INeed row wise difference in table matrix
Hi Team, I want to get row by row difference of value and want to show in table matrix. Input: Product Basic Deluxe Economy A 4 6 5 B 9 5 1 C 8 1 7 D 5 2 5 E ...
bhuprakashs , Create a visual calculation like this and hide the original measure, assuming this a matrix. Else do for all three measures and hide original
Calculation = if([Brand] ="Brand 1", [Net], [Net]- PREVIOUS([Net]))Visual Calculations RUNNINGSUM, RANGE, MOVINGAVERAGE, COLLAPSE, COLLAPSEALL, EXPAND, EXPANDALL, FIRST, LAST, PREVIOUS, and NEXT
https://www.youtube.com/watch?v=bKD9T0EWgQo&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
bhuprakashsHelper I
Helper IDataVitalizer thanks for the help. but I am using live connection as a data source so can not make changes in dataset. any way solution with DAX ?
amitchandak , Thanks Amit . I am checking your solution but I do not want to keep original columns in the table. Any other solution ?
DataVitalizer
Super User
Super UserI'm glad amitchandak's solution worked for you.