Forum Discussion
Using a measure in a calculated column
Hi, I have this calc col -> Punctuality = IF (OTIF[ShiftInTime]<OTIF[TimeFrom]-1/24*.25,"Early", IF (OTIF[ShiftInTime]>OTIF[TimeFrom]+1/24*.25,"Late","On Time" & IF (OTIF[ShiftInTime]>OTIF[Tim...
Use of Parameters would be more appropriate solution in your case.
Parameters? Can you tell me how I can do this?
Can you please provide me a snapshot your dataset and I would be more than happy to provide you exact solution.
Here's my file. I had a go at adding a parameter and applying the values in my OT% table to it. Parameter name is OTP%.
