Forum Discussion
Calculated column not working
Hi, For some reason my calculated column is no working - all values are a decimal number. DAX is TestRange70to79.9 =
IF(
AND(
[Supplier Percentage Conv] >= 'Time Penalty'[Left...
Hi Dhairya ,
Thats interesting - I hardcoded the 77.16
In the PBI it is using
Supplier Percentage Conv = [Supplier Percentage]*100
which uses
Supplier Percentage = divide([WFM - Supplier Working Time],[WFM - Supplier Scheduled Time])
Though it is hard-coded, I think it should work with measures also.
and instead of creating this measure Supplier Percentage Conv = [Supplier Percentage]*100
you can format your previous measure as a percentage