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

Hi Amzad You could try IF (ISBLANK( [Site] ) || [Site] = "" , "UNK" , [Site] )

Forum Discussion

Frequent Visitor

8 years ago

Solved

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
8 years ago
Hi Amzad

You could try

IF (ISBLANK( [Site] ) || [Site] = "" , "UNK" , [Site] )
kish1966
8 years ago
pep mp3 downloader apk
Yggdrasill
8 years ago
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.