Forum Discussion

miltenburger's avatar
miltenburger
Icon for Helper V rankHelper 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
Icon for Microsoft Employee rankMicrosoft 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
    Icon for Helper V rankHelper 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
      Icon for Helper I rankHelper 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.