Datesbetween

[armely]

am trying to incorporate hours in datesbetween, we have a need where it can be a dates plus 30hrs to show a range of activities. Datesbetween and periods only allows me to do dates instead of hours. Any suggestions on how to incorporate time.

Thanks

[PattemManohar]

@armely Try this as a New Column.... Instead of 30hrs splitted that into 1 Day 6 Hours....

TimeAdd = DATEADD(_Date[Date],1,DAY) + TIME(6,0,0)

[armely]

where this is tricky is time will vary from date to date. If we have a dataset as follows

3/10/19 1:00

3/10/19 3:00

3/12/19 10:00

3/12/19 14:00

3/13/19 12:00

and a user picks 3/13/2019 08:00 AM, then we want to subtract 30hrs from it so the result set will be between 03/12/2019 02:00 AM and 3/13/2019 08:00 AM thus the result should be as follows

3/12/19 10:00

3/12/19 14:00

[v-chuncz-msft · Accepted solution]

@armely ,

You may add a separate table for Slicer, use DATEDIFF to apply virtual relationship in DAX measure and then take advantage of Visual level filters.

https://community.powerbi.com/t5/Desktop/Use-a-date-slicer-to-filter-on-a-period-instead-of-a-single...