Forum Discussion
Anonymous
6 years agoNot applicable
Compare dates
Hi there, my aim is to compare two dates within an if clause. Naturally, the formula should show all values, if their date is larger than my selected date (03.08.2020). But I don't know why the...
- 6 years ago
If you use a date column from the same table in your slicer, it filters that table and prevents your desired functionality. You can make a simple DAX table to be used in your slicer instead, then store the selectedvalue in a variable for comparison in the rest of your expression.
SlicerDates = DISTINCT('NPLM Import'[Plan R@R ...])
Ć Annual Turnover (EUR) Done = var thisdate = SELECTEDVALUE(SlicerDates[Plan R@R ...]) Return IF( MAX('NPLM Import'[Plan R@R (internal) Date]) >= thisdate, IFERROR(SUM('NPLM Import'[Yearly average turnover (EUR)]), "") )If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
lbendlin
6 years agoSuper User
What happens when
Dates[DayOfMonth]
is 31 ? š
You may want to use variables to debug you measure and see where it breaks.
By the way, generally you can just say max(date)+1 or you can use DATEADD()