topic Re: Help me create Calculated Column in DAX Commands and Tips

Help me create Calculated Column

FrankWoody — Thu, 02 Jun 2022 08:42:06 GMT

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 ?

Re: Help me create Calculated Column

SpartaBI — Thu, 02 Jun 2022 08:49:37 GMT

FrankWoody

Column = SWITCH( 'Table'[Item Column], "A", 1, "B", 0.85, "C", 0.65, "D", 0.5 )

And then, format this column as percentage

Showcase Report – Contoso By SpartaBI

Re: Help me create Calculated Column

FrankWoody — Thu, 02 Jun 2022 09:03:35 GMT

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?

Re: Help me create Calculated Column

SpartaBI — Thu, 02 Jun 2022 09:43:37 GMT

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 🙂