Forum Discussion
Difference between rows by grouping with multiple columns
Hi All, I am quite new to Power BI. I have a table where I have to calculate the difference between previous yr and current yr value by grouping data by different attributes. Year Univ Schoo...
Hi Anonymous
First , you need create a measure to return the previous value .
PreviousValue = CALCULATE(SELECTEDVALUE('Table'[Value]),FILTER(ALLEXCEPT('Table','Table'[Univ],'Table'[School]),'Table'[Year]=SELECTEDVALUE('Table'[Year])-1))Then create a measure to count the diff between previous year and current year .
Diff = IF([PreviousValue] <> BLANK(),SELECTEDVALUE('Table'[Value])-[PreviousValue],BLANK())Finally, put these two measures in your table visual , you will get a result like below .
Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
