Help with IF statement

[miltenburger]

Hi people,

I need some help with my if statement. 

I need a new column based on following statements (see picture for three different columns right now)* 

* "G" = Aantal geboekt <= Uren Gecalculeerd

* "O" = Aantal geboekt <= Uren Gecalculeerd + Uren Risico Opslag & > Uren Gecalculeerd + Uren Risico Opslag

* "R" = Aantal gebpekt > Uren Gecalculeerd + Uren Risico Opslag

Hope you guys can help me out, thanks in advance

Kind regards Miltenburger

[anandraman]

TryTry this:

=IF( Aantal geboekt <= Uren Gecalculeerd ,"G",
IF(Aantal geboekt <= Uren Gecalculeerd + Uren Risico Opslag && Aantal geboekt > Uren Gecalculeerd + Uren Risico Opslag , "O",
IF(Aantal gebpekt > Uren Gecalculeerd + Uren Risico Opslag,"R")))

[miltenburger]

Thanks @anandraman

I thought this was the solution, but it seems that there are still some wrong calculations in it

[miltenburger]

In addition to this, to orange one doesn't seems te work

[anandraman]

Can you please share the PBIX file with this sample data ?

[miltenburger]

Here is my test data

PBIX file

[v-huizhn-msft]

Hi @miltenburger，

Please check logic of the second condition above is unclear as @anandraman said. And from your .pbix file, you add SUM(Blad1[Aantal geboekt]), SUM(Blad1[Uren Gecalculeerd]) and SUM(Blad1[Uren Risico Opslag]), please use them in the measure like the following formula.



Best Regards,
Angelia

[miltenburger]

Hi @v-huizhn-msft and @anandraman, thanks for the reply

See the error below: 

I also tried something else, but it only gvies me the "G" value....

[anandraman]

I think the logic which is to be implemented has some conflict with other one. Please check this once and then try implementing the logic.

[anandraman]

Can you please check this condition?

* "O" = Aantal geboekt <= Uren Gecalculeerd + Uren Risico Opslag & > Uren Gecalculeerd + Uren Risico Opslag