Forum Discussion

Devsh's avatar
Devsh
New Member
3 years ago

IF(ISBLANK)

I want to create a new column to retrieve blank cells from column [CC] in the table. I tried using =If(ISblank(Table Name[CC]),1,0) but it does not work. I also tried changing the data type from any to txt but still not giving desired output. Please help.

Need Help

1 Reply

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    3 years ago

    Hi,

    I assume you want to create a measure and put it into the visualization.

    Please try something like below whether it suits your requirement.

     

    Empty measure: =
IF ( ISBLANK ( MAX ( 'Open Order Report Data'[CC] ) ), 1, 0 )