Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Could someone please help me convert this excel formula to DAX syntax?
=IF([@ARDivisionNo]="08", "Avertx Billing",IF([@[Current Product Line']]]="SAAS","SAAS Billing",IF([@[Current Product Line']]]="SUBS","SAAS Billing",IF([@[Current Product Line']]]="PERP","Perpetual Billing",IF([@[Current Product Line']]]="BDSW","Bundled Software Billing","Hardware Billing")))))
Thanks!!
Solved! Go to Solution.
Try this:
SWITCH(
TRUE,
[ARDivisonNo] = "08", "Avertx Billing",
[Current Product Line] = "SAAS", "SAAS Billing",
[Current Product Line] = "SUBS", "SAAS Billing",
[Current Product Line] = "PERP", "Perpetual Billing",
[Current Product Line] = "BDSW", "Bundled Software Billing",
TRUE, "Hardware Billing"
)
The SWITCH function will evaluate each condition from top to bottom, stopping when it returns a result of TRUE and returning the matching result. You might have to modify the above to take into account the table names your columns come from.
Try this:
SWITCH(
TRUE,
[ARDivisonNo] = "08", "Avertx Billing",
[Current Product Line] = "SAAS", "SAAS Billing",
[Current Product Line] = "SUBS", "SAAS Billing",
[Current Product Line] = "PERP", "Perpetual Billing",
[Current Product Line] = "BDSW", "Bundled Software Billing",
TRUE, "Hardware Billing"
)
The SWITCH function will evaluate each condition from top to bottom, stopping when it returns a result of TRUE and returning the matching result. You might have to modify the above to take into account the table names your columns come from.
That worked thank you!
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
13 | |
11 | |
9 | |
6 |