Custom-made table with multiple measures ?

[acg]

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?

[tamerj1]

Hi @acg 
Most probably is doable but you need provide more details about your data, tables, relationships and sample explanation of each measure. Screenshots and sample data would be extremely helpful.

[amitchandak · Accepted 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