Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Meassure with replace/substitue

Okay guys   I need to find out how to solve this.    Your help is much appreciated.    As you can see in the picture the measure "Return Value" is the same measure as above just with a minus. ...
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hello Guys 

 

just to be clear. I want the output in a table to be like this

 

 

Greg_Deckler , thanks! I dont know how to send you data example. Im sorry, but I hope you should be able to understand my issue now.

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hello again

     

    I managed to find out how to make a calculated column for the change of SO art.

     

    Now i just want this formula into a measure.

     

    =IF(OR(Tabel1[PrognoseID]=9002970;Tabel1[PrognoseID]=9003090);SUBSTITUTE(Tabel1[SO art];"ZP01";"ZP0000");[SO art])