Calculate Aging of Workorder open by month

[RubenBC]

Hi All,

I have a list of workorders with the ID, starting date and close date and I need to count the number of workorder open by end of month and slip them between <30 days, 30 to 60 and >60days. I have grouped the ranges of age in a table and I have included some measure that I saw in similar questions, but they don't work as expected for my issue.

This is the result of the measure

And this is what I expect to have

The results changes if the open day is 1st day of month or 2nd day of month. Also I think the measure is taking the first day of month and not the last day.

These are the table and the measures

Any help would be greatly appreciated.

Regards

[RubenBC]

Hi,

I found the issue in the measure, I missed to include the workorder number in the ALL expresion.

Thanks

[RubenBC]

Hi Greg,

The links you share are almost what I need but I still need to group the orders per days, I mean how many open orders have <30, between 30 to 60 and <60, per month.

Thanks

[RubenBC]

Thanks I will take a look

[Greg_Deckler · Accepted solution]

@RubenBC 
Take a look at these two Quick Measures as I think you want something like them.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364
https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365