Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
miltenburger
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

newcolumn.png

 

 

Hope you guys can help me out, thanks in advance

 

Kind regards Miltenburger

 

9 REPLIES 9
anandraman
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

 

notgood.png

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

Orange.png

 

 

 

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.

1.PNG

Best Regards,
Angelia

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

 

See the error below: 

 

ERROR.png

 

 

 

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

error2.png

 

 

 

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

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.