Matrix with values group by custom Columns headers and Custom rows.

[matandradef]

Hello guys!
I have two different metrics in a table of excel: Actual Payments and Budget Payments (they are different metrics in power bi also).

I've created some custom period metrics like Actual Payments YTD, Actual Payments MTD etc but I need these metrics grouped by custom period in the rows like in the image below. 

Anyone can help me create these same tables in Power BI? I have a date column too.

Thank you

[Anonymous · Accepted solution]

HI @matandradef,

For your requirement, you can also try to create a table with all category type values. Then you can use this field on matrix and write a measure formula with switch function to use on matrix value field to achieve your requirement.

Solved: Re: DAX SWITCH + SELECTEDVALUE() - Microsoft Fabric Community

Regards,

Xiaoxin Sheng

[matandradef]

Many thanks! You saved my life.

[amitchandak]

@matandradef , You can get that using calculations groups. They are now available on desktop

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0