Forum Discussion
Solved
Help me create Calculated Column
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...
Column = SWITCH( 'Table'[Item Column], "A", 1, "B", 0.85, "C", 0.65, "D", 0.5 )
And then, format this column as percentage
Column =
SWITCH(
'Table'[Item Column],
"A", 1,
"B", 0.85,
"C", 0.65,
"D", 0.5
)
And then, format this column as percentage