Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 ...
  • Stachu's avatar
    Stachu
    6 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
6 years ago
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
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Many thanks for your suggestions