Converting to DAX

[Amzad]

 I Have a  null and Blank  Fields in a  Sites Column  can any give me DAX function 

if it's in SQL i can achive  using   -->  isnull  (nullif  ([site],'') ,'UNK') as [Site] 

can any one give me a DAX function to it Please 

Thanks 

[Phil_Seamark · Accepted solution]

Hi @Amzad

You could try

IF (ISBLANK( [Site] ) || [Site] = "" , "UNK" , [Site] )

[kish1966 · Accepted solution]

pep mp3 downloader apk

[Phil_Seamark · Accepted solution]

Hi @Amzad

You could try

IF (ISBLANK( [Site] ) || [Site] = "" , "UNK" , [Site] )

[Amzad]

Hey Phil, Thanks for reply   its not working 

as i'm new to Power BI side 

i have a table 'Business Attribute' with 'Site' Cloumn like 

NY

NJ

*

TX

Blank

MA

             I want to replace  Blank and *  as a Unknow (Like UNK)  

[Yggdrasill · Accepted solution]

Like @Phil_Seamark points out.

Create a calculated column in the table where [Site] column is and use his formula. You might need to use ";" instead of "," depending on your locale settings.

[Amzad]

Thanks  @Phil_Seamark   && @Yggdrasill    it works :smileyhappy :  Thanks Again

[kish1966 · Accepted solution]

pep mp3 downloader apk