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

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

 

 

 

anandraman's avatar
anandraman
Icon for Helper I rankHelper I
8 years ago

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

    • anandraman's avatar
      anandraman
      Icon for Helper I rankHelper 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
      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....