Forum Discussion
Solved
DAX code for comparing dates not working?
I have an open date and close date in my table, and have them related via inactive links to a date table. I historically have used the following rolling measures to capture opens/closures within flex...
- Solved it myself - for some reason it previously defaulted to "today" as a max on the dates. Now that has to be declared specifically so you need to do the following: Created 4XCycle Day Rolling Measure = Calculate( DISTINCTCOUNT(Table[Key]), USERELATIONSHIP('Date'[Date], Table[CreateLink]), FILTER(Table, Table[CreateLink]>=Min(([Todaysdate]-(4*[Cycle Length])),(Max('Date'[Date])-(4*[Cycle Length]))), FILTER(Table, Table[CreateLink]
Solved it myself - for some reason it previously defaulted to "today" as a max on the dates. Now that has to be declared specifically so you need to do the following: Created 4XCycle Day Rolling Measure = Calculate( DISTINCTCOUNT(Table[Key]), USERELATIONSHIP('Date'[Date], Table[CreateLink]), FILTER(Table, Table[CreateLink]>=Min(([Todaysdate]-(4*[Cycle Length])),(Max('Date'[Date])-(4*[Cycle Length]))), FILTER(Table, Table[CreateLink]