Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get 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

Reply
alejandrodelgad
Frequent Visitor

Aging Totalization for Matrix Report

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

2020-03-26_17h51_18.png

2020-03-26_17h53_19.png

I have created a measure that assign this Orders age schema 

2020-03-26_17h18_43.png

So the result in a normal table is this

2020-03-26_17h18_27.png

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

2020-03-26_17h43_49.png

How can i get the Measure Result to allow me do it?

2020-03-26_17h48_09.png

Please help

Thanks in advance for your help

 

1 ACCEPTED 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



Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

View solution in original post

7 REPLIES 7
Stachu
Community Champion
Community Champion

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.



Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

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

 

 

Orders Age Grouping.jpg

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



Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

Many Many Many Thanks!!!! I was obsessed adding IFs hahahaha

Hi, Thanks for your response, finally i managed to set the days count from order date to todays date using the duration option at Edit Query/Transform son is not a measure anymore but still looking for translate the amount of days to the classification i need to totalize, any suggestion? I'm thinking to insert it from an excel file or create a conditional column with all the values, with this second option i don't get the expected result 1-3 3-7 7-15 15-30 30-60 60-90 90+ Thanks
Anonymous
Not applicable

You should have the labels of the classification stored in a dimension and connected the your fact table. Each order can be assigned one member from the dimension and this is how you slice data. The classification should be performed in Power Query.

Here's how to build correct and predictable models:

https://www.youtube.com/watch?v=_quTwyvDfG0

https://www.youtube.com/watch?v=78d6mwR8GtA

Best
D

Many thanks for your suggestions

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.