Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
33 | |
15 | |
14 | |
13 | |
9 |
User | Count |
---|---|
58 | |
23 | |
22 | |
19 | |
13 |