Forum Discussion
Solved
Split rows depending on time span
Hi there, I am working with a report in which I would like to analyze data on a weekly basis. The issue that I'm having is that there are some rows that go from let's say sunday 17:00 to monday 3...
Hi , GuerauFF
You only need to add additional judgment condition to determine whether the weeknum of the two dates is the same, and then determine the number of expanded rows. If the date weeknums are different, the number of expanded rows is 1, otherwise the number of expanded rows is 0
The result will show as below:
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
GuerauFF , please check if logic in this file can help you
https://www.dropbox.com/s/5wo5jhzl488zy69/Minute_between%20Hours.pbix?dl=0
Not sure why but I can't download the file...