Counting from an Specific date and time.........................................DAX?????????????????

[christianfcbmx]

Hi guys! I need Ideas please!

Does it exist an slicer which allows me to choose between 2 dates and time?

I have some data set where I have an specific date and time for example (dd-mm-yyyy hh:mm:ss) associated to a number and I need to count between...my problem is that I do not only need to pick up a date but also time... for example I need to count between 5 pm today to 9 am the day after... the idea is to find something like an slicer...

Somebody has an idea to try to solve this in some way....any idea would be so much appreciated!!!

[v-piga-msft]

Hi @christianfcbmx,

If I understand your requirement correctly that you want to have a slicer to filter both date and time. I found that the Time Brush visual may achieve it.

You could import the visual from marketplace and the output is like below.

You could select a time period by dragging the highlight in orange and any visuals will be automatically filtered.

 

Reference: my test pbix file.

Hope it can help you!

Best Regards,

Cherry