As you can see in the picture the measure "Return Value" is the same measure as above just with a minus.
When I take that meassure into a pivottable as a vakue and select column SO art and colmn Prognose as rows ; I want column "SO art" ZP01 to be ZP00, but only for PrognoseID 9002970.
Its important to do it in a measre and not a column, if possible. I tried to read about substitute but could not really make it work.
Is there anyway to solve this? or next best would be in a calculated column.
I want the new measure to have the same value, but some values in one column based on another coulmns ID, need to be swtiched. (only for this meassure).
So in the end when I out both values in a table with SO art og Prognose ID as rows we would see that prognose ID 9002970 has SO art ZP01 in first measure "value with original string" but ZP00 in measure "Return Value"