topic Re: Date-Between slicer change time consideration in DAX Commands and Tips

Date-Between slicer change time consideration

kitti — Sat, 28 Mar 2020 08:20:19 GMT

Hi,

I need help. I created a date-between slicer, I want to change the time manner though.

Normally, a day is from 00:00:00 A.M. til 11:59:59 P.M.

How do I alter it to be 07:00:00 A.M. - 06:59:59 A.M. in date-between slicer?

For instance: when I chose 01-JAN-2020 and 02-JAN-2020, it would consider as 01-JAN-2020 07:00:00 A.M. to 02-JAN-2020 06:59:59 A.M.

My data simply looks like this:

DATE_KEY	DATE
1	1-Jan-20
2	2-Jan-20
3	3-Jan-20
4	4-Jan-20

Thanks in advance,

Re: Date-Between slicer change time consideration

Anonymous — Sat, 28 Mar 2020 09:00:09 GMT

Mark your column as date time and check.
I have never tried date time between slicer. But still you can check it out.

Thanks
Pravin

Re: Date-Between slicer change time consideration

Anonymous — Sat, 28 Mar 2020 09:11:33 GMT

What you have to do is CREATE YOUR OWN CUSTOM CALENDAR. There is no other way. And when you do this... you have to forget about the time-intel functions. You'll have to write your own.

Easy as that.

Best
D

Re: Date-Between slicer change time consideration

kitti — Sat, 28 Mar 2020 11:17:12 GMT

It doesnt have to be a date slicer literally if anything else works. Anyway, can you give an example of doing that?

Thanks

Re: Date-Between slicer change time consideration

Anonymous — Sat, 28 Mar 2020 13:06:54 GMT

One other option is to write measures that will change the usual meaning of days in their code. But that could be tedious if many measures must be affected. You can try to do this, though, since everything is possible in DAX code.

Best
D