cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PrivateAnalytic
Helper III
Helper III

Is there a way I can do a DAX column similar to this? But for another result?

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
1 REPLY 1
vanessafvg
Super User
Super User

I can't see why not.   Have you tried to do it?  

example, but using year.

ie IF(CurrentYr >= DateYr"Yes""No")





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Helpful resources

Announcements
Winner of T-Shirt Design

Power BI T-Shirt Design Challenge 2023

Find out who won the T-Shirt Design Challenge and the top 3 finalists.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.