Forum Discussion

android1's avatar
android1
Post Patron
10 years ago

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...
Need Help
BhaveshPatel's avatar
BhaveshPatel
Super User
10 years ago

Hi Android1,

 

Firstly you have to create parameter ( list of values) based on your IF% Table.

This can be done in powerquery mode. Pass on all the list of the values of IF% Table.

 

create a new custom column,

 

Pass on your formula you created before and replace the value of 0.25 with Parameter name.

 

This will let you choose the value later on dynamically and you can select the value of your choice.

 

Hope this will clarify your problem. I was unable to create this for you because of connection settings.

Parameter table creationPassing onto the Parameters to your custom column

BhaveshPatel's avatar
BhaveshPatel
Super User
10 years ago

You have to slightly change the formula for custom column as PowerQuery works on IF logic but have to add else statment too.

 

Let me know if you get stuck further.