Hey everyone! So currently I have a column in Power BI I created that flags items where dates are in the year 2022.
IsCurrentYear =
VAR CurrentYr = YEAR(MAX('FinanceFactTMAwardSpend'[Date]))
VAR DateYr = YEAR(FinanceFactTMAwardSpend[Date])
Return
IF(CurrentYr = DateYr, "Yes", "No")
I was wondering if it was possible if I can do the same thing, but for a date that is only on or after a specific date? Like 08/01/2022