Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi, i am creating a Report about open orders and i want to create a matrix totallized by Division ( PLC) and after that by Age of the orders ( days from order to actual date).
The Age schema is the following [ 1-3/3-7/7-15/15-30/30-60/60-90/90+]
I have calculated the days from order date to todays date with this measure
I have created a measure that assign this Orders age schema
So the result in a normal table is this
But when i try to set it up in the Matrix visualization, Power Bi dont allow me to add the Agign result to the rows field so i cant set it up this way
How can i get the Measure Result to allow me do it?
Please help
Thanks in advance for your help
Solved! Go to Solution.
it's missing else in the last if, you can change it from
you can remove the last row and add "90+" as else variant for the previous one
in order to display something in rows it has to be in a column, cannot be in a measure. So basically you need a column that would have values like '90+ days', '60-90 days' etc.
Hi Again, i ave tried to create a Custom Colum with this configuration, but looks like i am missing something that dont allow me to apply it. Any Suggestion?
I also added ( and , to split each if and colse all ) at the end of the formula but same result
it's missing else in the last if, you can change it from
you can remove the last row and add "90+" as else variant for the previous one
Many Many Many Thanks!!!! I was obsessed adding IFs hahahaha
Many thanks for your suggestions
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
22 | |
21 | |
20 | |
14 | |
11 |
User | Count |
---|---|
43 | |
34 | |
25 | |
23 | |
23 |