Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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 ?
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |