Forum Discussion

miltenburger's avatar
miltenburger
Helper V
8 years ago

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 Geca...
Need Help
v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
8 years ago

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's avatar
miltenburger
Helper V
8 years ago

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's avatar
    anandraman
    Helper I
    8 years ago

    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.