Forum Discussion
harib
6 years agoPost Patron
Conditions for Columns
Hi All, I have senario like below table . Main Table SNO MG MU MP LG LU Percentage1 Percentage2 1 XX AA BB CC DD ...
Anonymous
6 years agoNot applicable
"I woluld like to give condition like if it is MG, MU then in column1 it should come Yes , if it is LG, LU then in column 2 it should come No. "
Can you clarify?
If MG=MU?
I guess that you're showing an actual table (and not a visual), so you can do that either in PowerQuery M or in DAX. Both solutions are equivalent.
I would do
Column1=IF(Table[MG]=Table[MU];"Yes")
but you first need to clarify the question
harib
6 years agoPost Patron
Updated the Requirment. Can u please give me the solution.