Forum Discussion
DATEADD
I am using a meausre to create a vertical line at a certain point This DAX creates the line succesfully referenceline = IF( MAX('FACT SALES'[Date]) = DATE(2020,5,1), 20000, // hei...
Anonymous
You can use the below measures.
Max Date = MAX(Supplier[Date])
MAX Date1 =
var _mm = MONTH([Max Date])
var _dd = DAY([Max Date])
var _year = YEAR([Max Date])
return
IF ([Max Date] = DATE(_year,_mm,_dd), 5000, Blank())
You are comparing the max date by breaking the year, months and date of max date in parts. But why have you reduced the month by 1.
This will obviously not match the MAX Date for Sales.
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!!