Forum Discussion
Solved
Need help with Formula
Hello, I need help with formula because I can't figure out why that simple formula doesn't works. Example: I have this table. I used this formula: COLUMN3 = IF('Planas vs Faktas'[Plan]-'...
Hello EdgarasR1
You can create a measure like so to get your result.
Measure = VAR _Fact = SUM ( 'Planas vs Faktas'[Fact] ) VAR _Plan = SUM ( 'Planas vs Faktas'[Plan] ) RETURN IF ( _Fact > _Plan, 0, _Plan - _Fact )You should create measures for each of the amount though then use those measures.
Fact Amount = SUM ( 'Planas vs Faktas'[Fact] )Plan Amount = SUM ( 'Planas vs Faktas'[Plan] )Plan-Fact = [Plan Amount] - [Fact Amount]Then the final measure would be just this:
Measure = IF ( [Fact Amount] > [Plan Amount], 0, [Plan-Fact] )
Hello EdgarasR1
You can create a measure like so to get your result.
Measure =
VAR _Fact = SUM ( 'Planas vs Faktas'[Fact] )
VAR _Plan = SUM ( 'Planas vs Faktas'[Plan] )
RETURN IF ( _Fact > _Plan, 0, _Plan - _Fact )
You should create measures for each of the amount though then use those measures.
Fact Amount = SUM ( 'Planas vs Faktas'[Fact] )Plan Amount = SUM ( 'Planas vs Faktas'[Plan] )Plan-Fact = [Plan Amount] - [Fact Amount]Then the final measure would be just this:
Measure = IF ( [Fact Amount] > [Plan Amount], 0, [Plan-Fact] )