Forum Discussion
Solved
Needed Help!!!
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...
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. :smileyhappy:
Regards
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. :smileyhappy:
Regards