Forum Discussion
Solved
Table row conditional Formula
Currently, I have next measure which gives the expected result for the rows 1801.00 and 0801.00:
"Formula 1"
CALCULATE(IF([Invoiced to date]<[Work Budget];
IF([Invoiced to date]<[Commitments];0;[Commitments]-[Invoiced to date]);
IF(AND([Commitments]<[Work Budget]; [Commitments]< [Invoiced to date]); [Commitments]-[Invoiced to date];MIN([Commitments];MIN([Invoiced to date];[Work Budget]))-( [Invoiced to date])) + [Manual Adjustments]) ;'Project budget lines'[Cost line] IN {"1801.00"; "0801.00"})
However, there's other rows as well, for which the calculation is different:
"Formula 2"
CALCULATE(IF([Invoiced to date]>[Work Budget];
IF([Invoiced to date]>[Commitments];0;[Commitments]-[Invoiced to date]);
IF(AND([Commitments]>[Work Budget]; [Commitments]> [Invoiced to date]); [Commitments]-[Invoiced to date];MAX([Commitments];MAX([Invoiced to date];[Work Budget]))-( [Invoiced to date])) + [Manual Adjustments]) ;'Project budget lines'[Cost line] <> {"1801.00"; "0801.00"})
How to combine these formula's into one measure, resulting in one column:
Row Code Column A Value
0801.00 " value based on formula 1'
1801.00 "value based on formula 1'
2000.00 " value based on formula 2'
2000.01 " value based on formula 2'
2000.02 " value based on formula 2'
2300.04 " value based on formula 2'
Anxious which PowerBI guru can help me in this!
As per need create the that cloumn as measure:
Measure=sum(Project budget lines'[Cost line])
Later
Measure 1= if(Measure in condtion, Formula1, Formula2)
4 Replies
hthotaResolver III
Create a measure as given below:
Measure= if(Project budget lines'[Cost line] IN {"1801.00","0801.00"},Formula1,Formula2)
Hi,
thanks, makes sense, however I cannot select/set the Table field (Project budget lines'[Cost line] ) in the measure. It's only coming up with other measures, and not with table values?
- hthota
As per need create the that cloumn as measure:
Measure=sum(Project budget lines'[Cost line])
Later
Measure 1= if(Measure in condtion, Formula1, Formula2)
