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.
Hi all!
I am looking for a DAX formula that can do the following:
multiply the column "FTEquiv" (in the table sheet1) by:
0.9 if the calculated column "Column2" in the 'Pathways SU Data' table is "Block Contract"
by:
1 if the calculated column "Column2" in the 'Pathways SU Data' table is "1:1"
and by:
2 if the calculated column "Column2" in the 'Pathways SU Data' table is "2:1"
Thanks in advance!
mycolumn =
SWITCH (
TRUE (),
Table[col2] = "Block Contract", .9,
Table[col2] = "1:1", 1,
Table[col2] = "2:1", 2
) * Table[FTEquiv]
Hi @cammar ,
You don't say, so this is a calculated column.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
Proud to be a Super User!
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
24 | |
9 | |
7 | |
6 | |
6 |
User | Count |
---|---|
29 | |
11 | |
11 | |
10 | |
6 |