Forum Discussion

Amzad's avatar
Amzad
Frequent Visitor
8 years ago
Solved

Converting to DAX

 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 ...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

    Hi Amzad

     

    You could try

     

    IF (ISBLANK( [Site] ) || [Site] = "" , "UNK" , [Site] )
  • Yggdrasill's avatar
    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.

Yggdrasill's avatar
Yggdrasill
Responsive Resident
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.

Amzad's avatar
Amzad
Frequent Visitor
8 years ago

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