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.
Hi Power BI Community,
I am creating a Dax formula with Switch (True()) case:
Solved! Go to Solution.
@Anonymous
Try this one
Nested If = SWITCH ( TRUE (), Data[Margine C] <= 0.00, "<=0%", Data[Margine C] <= 0.15, ">=0% <15%", Data[Margine C] <= 0.20, ">=15% <20%", Data[Margine C] <= 0.30, ">=20% <30%", Data[Margine C] <= 0.50, ">=30% <50%", Data[Margine C] > 0.50, ">= 50%" )
@Anonymous
Try this one
Nested If = SWITCH ( TRUE (), Data[Margine C] <= 0.00, "<=0%", Data[Margine C] <= 0.15, ">=0% <15%", Data[Margine C] <= 0.20, ">=15% <20%", Data[Margine C] <= 0.30, ">=20% <30%", Data[Margine C] <= 0.50, ">=30% <50%", Data[Margine C] > 0.50, ">= 50%" )
@ Zubair_Muhammad, thank you it worked.