Forum Discussion

GuerauFF's avatar
GuerauFF
Helper II
6 years ago
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...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-easonf-msft's avatar
    v-easonf-msft
    6 years ago

    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:

     

     

    Pbix attached

     

    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.

v-easonf-msft's avatar
v-easonf-msft
Community Support
6 years ago

Hi ， GuerauFF 

Does it mean that you just want to split the rows that  StartDate is Sunday and EndDate is Monday ?

 

Best Regards,
Community Support Team _ Eason

GuerauFF's avatar
GuerauFF
Helper II
6 years ago

Exactly!

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    6 years ago

    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:

     

     

    Pbix attached

     

    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.