Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Gurus & Masters
I get stucked with this issue.
I want to privde a snapshot of monthly work order backlog.
Simulated and tested in Excel, the history backlog on a particular reporting time to be count of work orders that:
1. Raised Date <= Reporting Date, and
2. Closed Date >= Reporting Date.
How can I get the result in Power Bi? Really appreciate your help.
A sample below.
WO | Raised Date | Closed Date |
1 | 1/02/2022 | 5/02/2022 |
2 | 1/03/2022 | 5/03/2022 |
3 | 1/03/2022 | 5/04/2022 |
4 | 1/04/2022 | 5/04/2022 |
5 | 1/04/2022 | 5/05/2022 |
Solved! Go to Solution.
@Austinger , Refer my blog on similar item
different approch
Tables way
https://amitchandak.medium.com/dax-get-all-dates-between-the-start-and-end-date-8f3dac4ff90b
https://amitchandak.medium.com/power-query-get-all-dates-between-the-start-and-end-date-9ad6a84cf5f2
@Austinger , Refer my blog on similar item
different approch
Tables way
https://amitchandak.medium.com/dax-get-all-dates-between-the-start-and-end-date-8f3dac4ff90b
https://amitchandak.medium.com/power-query-get-all-dates-between-the-start-and-end-date-9ad6a84cf5f2
Cool Cool, nice, thanks for helping me out! Champion!