Hi! Everyone. Hope you are all well!
Need a help from you all.
I have table of equipment downtime with start and end date/time.
Would like to have a results like as show below. Result that generates a dates in between so I can have the downtime hours in between.
Thank you and appreciate your kind help.
Go to Solution.
Between Dates - Dates between
Measure wayPower BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzMhttps://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-o...
Tables way https://amitchandak.medium.com/dax-get-all-dates-between-the-start-and-end-date-8f3dac4ff90bhttps://amitchandak.medium.com/power-query-get-all-dates-between-the-start-and-end-date-9ad6a84cf5f2
View solution in original post
Thanks a lot @amitchandak
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.