topic Re: Date Filter in DAX Commands and Tips

Date Filter

Anonymous — Thu, 10 Mar 2022 15:20:34 GMT

Hi!

I was wondering if there was a way for me to have the following date filter and have it filter data to show all the data before and including the date selected?

Thank you!

Re: Date Filter

Whitewater100 — Thu, 10 Mar 2022 15:41:04 GMT

Yes:

You can choose Date Slicer and choose "Before" as relative Date. When you drag your date filed into the slicer you will notice a little carot symbol intop right corner of visual. From this dropdown you can choose relative dates.

Hope this helps..

Re: Date Filter

Anonymous — Tue, 15 Mar 2022 09:34:54 GMT

Hi Anonymous ，

In your slicer, the date is put together with "today" and "yesterday", which means that the date is also in text format. If you want to write dax to implement that may not be as convenient as Whitewater100 .

I think Whitewater100 's workaroud is good, you can try it.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.