Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a column containing items like A,B,C,D.
I would like to create a calculated column evaluating the following question: If the row of this column is equal to "A" then return 100%, If the row of this column is equal to "B" then return 85% ,
the row of this column is equal to "C" then return 65%, the row of this column is equal to "D" then return 50%. is it possible to do that ?
Solved! Go to Solution.
Column =
SWITCH(
'Table'[Item Column],
"A", 1,
"B", 0.85,
"C", 0.65,
"D", 0.5
)
And then, format this column as percentage
THANKS So much !
Now is there any way for me to assign these values to specific texts, if I have a character set and want to filter a part of the text of the line does it also work?
@FrankWoody my pleasure.
Sure you can, check out this function:
https://dax.guide/containsstring/
You can also explore there related functions.
Don't forget to mark my previous respond as a solution for comunity visabilty.
P.S. check out my showcase report:
https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543
Give it a thumbs up over there if you liked it 🙂
Column =
SWITCH(
'Table'[Item Column],
"A", 1,
"B", 0.85,
"C", 0.65,
"D", 0.5
)
And then, format this column as percentage
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |