Needed Help!!!

[Billy0503]

Hello everyone,

i´m new quite new in this business and need some help to solve a problem i´m facing for several hours now.

Problem/Question:

Is it possible, if in the column "April TEUR" the value for some "FC_DATE" is 0,00. To replace the value 0,00 with the value of the column "April Actuals".

Please look at the attached picture as a help to understand my problem.

It should look like the next picture below, which is made in Excel (manually). The Blue values( Column April A. in my case) are those which are replacing the value 0,00 (Column FC april TEUR in my case). So everytime a value 0,00 appears, it should take the value of the Column April A., if the value 0,00 is in, then it should take the value which is given from the column FC April TEUR.

I hope really that you could help me with this one.

Thank you in advance for helping me 🙂

[v-ljerr-msft · Accepted solution]

Hi @Billy0503,

In this scenario, you should be able to use the formula below to create a new measure to recalculate the value of "April TEUR", and show the measure on your report to get the expected result.

April TEUR Mesure =
IF (
    SUM ( 'Table'[April TEUR] ) > 0,
    SUM ( 'Table1'[April TEUR] ),
    SUM ( 'Table1'[April Actuals] )
)

Note: You will need to replace 'Table1' with your real table name. 

Regards