Forum Discussion
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 ...
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
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
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
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