topic Re: Date filters in dax in DAX Commands and Tips

Date filters in dax

DustinD — Thu, 05 Oct 2023 19:06:59 GMT

I have a issue i can not figure out in dax. i have 2 date fields in my report. i will try my best to explain the issue. so date1 is a snap shot evrey monday and thursday. date2 is the last time a part was moved. what im trying to do in dax is make something that will only bring in date2 if its 5 days older then date1. i also want this to be dynamic. for example lets say they select date1 from 3 weeks ago. i want it to only bring in date2 if its 5 days older then the selected date. so in this case 5 days older then date1 from 3 weeks ago. thanks for the help.

Re: Date filters in dax

ValtteriN — Fri, 06 Oct 2023 06:08:24 GMT

Hi,

Here is one way to do this:

Test data:

Dax:

Test if older than 5 =

var _lastmoved = MAX('Table (3)'[LastMoved])

var _datediff = DATEDIFF(MAX('Table (2)'[SnapShotDate]),_lastmoved,DAY) return

IF(_datediff<=-5,1,0)

Now place this measure as a filter like this:

Now the dates displayed are only the ones where the part was moved more than 5 days ago. E.g. 29.9.2023 is not shown since the last moved was 24.9.2023 -> within 4 days of the date.

You can apply further filters and the logic will work the same.

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

Re: Date filters in dax

DustinD — Fri, 06 Oct 2023 13:12:07 GMT

ValtteriN I was able to make this work after doing some changes. thanks for help.