Forum Discussion
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 consecutive years are displayed (18/19 or 19/20 etc - changeable by filter) and the difference between the years. The description like: 'Number of Companies' are all custom made titles as requested by the stakeholder, that is they need to be custamizable. It needs titles like 2021 2020 Differnce (%). The numbers are all individual measures to attain the results.
This can be quite easily be done in Tableau:
How do I archieve it in Power Bi? Where do I look for a solution?
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
2 Replies
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
