Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

if statement Plus Count

I have two columns: Actual Planned   CountTheRow P1                   10        2              1 P2               6         10                1 P3               5                            1 P4...
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous 

 

You could do

IF( NOT( ISBLANK( [Actual] ) ) || NOT( ISBLANK( [Planned] ) ) ,1 ,0)

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thank you - this is very strange - I am translated into Spanish? And I cannot press tab or enter ... I think it is because I am the opposite part of the globe?


    Already

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Anonymous ,

       

      Every post here is translated from english to spanish and vis-a-varsa.

      Your post is also in english. Click the icon 

      on top right of this window you will see both posts. Right now there is no way to switch of spanish.

    • amitchandak's avatar
      amitchandak
      Super User
      5 years ago

      Anonymous , you will get both the English and Spanish messages. just check the correct ticket in your profile.

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        I think I need lessons on how to use this interface ... let alone power BI!
        -