Forum Discussion

kylee_anne's avatar
kylee_anne
Helper II
2 years ago
Solved

IsBlank

My nested ISBLANK doesn't seem to be working. 

I'm using this statement 

Full Schedule Add calcs 1 = ADDCOLUMNS('Full Schedule (2)',"Activity Name3",if(AND(ISBLANK('Full Schedule (2)'[Activity Name]),'Full Schedule (2)'[Category]="Shaft Lining"), CONCATENATE("Set ",'Full Schedule (2)'[Set(Final)]),'Full Schedule (2)'[Activity ID_1]))
And when my Activity Name is populated I'm getting Activity ID's.  Data from excel, exported from P6.  Ideas?

 

Need Help
  • kylee_anne's avatar
    kylee_anne
    2 years ago

    Yep I think you're right.  I've changed for now and using && plus A's rather than null or blank and it seems to work.

3 Replies

  • PijushRoy's avatar
    PijushRoy
    Community Champion
    2 years ago

    Hi kylee_anne 

    Your DAX code is looking wrong.
    Please share sample data (remove sensitive data) and share. Also, share what output you want,
    Thanks
    Pijush

  • kylee_anne's avatar
    kylee_anne
    Helper II
    2 years ago

    Yep I think you're right.  I've changed for now and using && plus A's rather than null or blank and it seems to work.

    • PijushRoy's avatar
      PijushRoy
      Community Champion
      2 years ago

      Hi kylee_anne 

      If it is solved now, please mark it as SOLUTION which helps other community users.

      If solved your requirement, please mark this answer as SOLUTION.
      If this comment helps you, appreciate your KUDOS

      Thanks 
      Pijush