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

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

  • anandraman's avatar
    anandraman
    Helper I
    8 years ago

    Can you please check this condition?

     

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

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