Forum Discussion
Quarte wise Data in Matrix Power BI
Hi rsharma81
You can use disconnected table + dynamic measures, I didn't find an example with the same scenario as yours, but the method in the linked blog post has the same logic.
You need to create a table with the wanted format of hierarchies and order columns and use the selectedvalue() DAX function.If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi Rita,
Thanks, It is really useful however, it seems that the Power BI installed on my system is before October and hence this option of Calculation is not available in it. Any other way we can achieve it?
Thanks for your kind help.
Super UserHi rsharma81
You can use disconnected table + dynamic measures, I didn't find an example with the same scenario as yours, but the method in the linked blog post has the same logic.
You need to create a table with the wanted format of hierarchies and order columns and use the selectedvalue() DAX function.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly