Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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 , 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
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |