Forum Discussion
Solved
Custom-made table with multiple measures ?
I like to ask whether the follwing is possible to do and where I need to search for a solution: I need to be able to present / list a number of items in a clean overview table, whereby consecutiv...
acg , If the rows are also split of measure. You need to use the calculation group for this year, last year, and change %
example
This Year = CALCULATE(sum('Table'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])))
Last Year = CALCULATE(sum('Table'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])-1))diff = [This Year]-[Last Year ]
diff % = divide([This Year]-[Last Year ],[Last Year ])Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
