Forum Discussion

SJHALANI's avatar
SJHALANI
Helper I
3 years ago

Create measure using DAX

Hi Guys! I have a column in my table which lists "'PO Year". It could have values 2021, 2022 or 2023. I want to create a new column measure called "PO Status" where if the PO year is 2021 or 2022,...
DAX help needed
devanshi's avatar
devanshi
Helper V
3 years ago

IF( OR([PO Year] = 2021 , [PO Year] = 2022 ), "Inactive", "Active")

OR

IF([PO Year] = 2021  ||  [PO Year] = 2022 , "Inactive", "Active")