Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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, PO Status should say "Inactive" otherwise "Active".
PO Year | PO Status |
2021 | Inactive |
2022 | Inactive |
2023 | Active |
What should be the DAX command to help me achieve this? I am new to DAX commands, so any help is appreciated. Thanks!
IF( OR([PO Year] = 2021 , [PO Year] = 2022 ), "Inactive", "Active")
OR
IF([PO Year] = 2021 || [PO Year] = 2022 , "Inactive", "Active")
Hi @SJHALANI
Please try
PO Status =
IF (
SELECTEDVALUE ( 'Table'[PO Year] ) IN { 2021, 2022 },
"Inactive",
"Active"
)
@SJHALANI
Ok, please try
PO Status =
IF (
SELECTEDVALUE ( 'Table'[PO Year] ) IN { "2021", "2022" },
"Inactive",
"Active"
)
User | Count |
---|---|
48 | |
44 | |
19 | |
14 | |
14 |
User | Count |
---|---|
107 | |
55 | |
28 | |
19 | |
14 |