Forum Discussion

christianfcbmx's avatar
christianfcbmx
Icon for Post Patron rankPost Patron
8 years ago

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

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!!!

 

 

Need Help
Tips and Tricks

1 Reply

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar
    8 years ago

    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