Forum Discussion

schans11's avatar
schans11
Frequent Visitor
3 years ago

calculation in matrix

Hi,

 

I am currently trying to calculated weeks of supply in a Power BI matrix. This goes well for the lowest level (green, 201/7), but not for the aggregate level (red, 35828/2461). 

 

Which function should I use to do this?

 

I am currently using the below function.

 

 

 

 

 

1 Reply

  • FreemanZ's avatar
    FreemanZ
    Super User
    3 years ago

    hi schans11 

    why not using the [weeks supply] measure in the last column of your second screeshot ?