Hi everybody,
Practicing with PP I created a calculated column with a nested IF that is producing a text output then used in my Pivot Table. Hereunder the calculated column fx.
=IF([SMCC Status]="Approved"; "Completed"; IF([MC %]>0,85&&[PLA]=0; "Ready 4 WD"; "Not Ready"))
I am wondering if I can transform this calculated column into a measure. Is this unlikely by being the result a text cell or is there any other way?
P.S. I could not attach the source file because of file size.
Thanks,
Alberto
Hi Alberto,
Measures are for the values area. I'm wondering why you can't you use that column in your PivotTable, rather than having to write it as a measure?
Mynda
Hi Mynda,
the only reason for that is related to column order. I have another measure (MC%) that I want to put before that column in the Pivot Table. At the moment the measure MC% is of course after the "Ready 4 WD" column. Instead I want to put them in reversed order.
Thanks,
Alberto
In that case maybe you'd be better off doing this in Power Query.
I can't do that because the MC% column is result of multiples measures created in PP with relations between tables. I can't redo these calculations in PQ. Ok then I keep the column order as is.
