Showing results for 
Search instead for 
Did you mean: 
Helper V
Helper V

Help with IF statement

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


Helper I
Helper I

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")))

Thanks @anandraman

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



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





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

Here is my test data


PBIX file

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,

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....





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.

Can you please check this condition?


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

Helpful resources

PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors