Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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
Hi,
I found the issue in the measure, I missed to include the workorder number in the ALL expresion.
Thanks
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
Thanks I will take a look
@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
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
90 | |
80 | |
60 | |
60 | |
58 |
User | Count |
---|---|
155 | |
119 | |
104 | |
78 | |
71 |