Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Please help convert SQL to DAX?

Hello, I am trying to create a new column in the query editor can someone please tell me the DAX for   case when nvl (STAFF_ABILITY_RESOLVE_ISSUES, 'N/A') = 'N/A' then null else to_number (STAFF_A...
Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

Hi Anonymous

 

I replied to your other post for the same thing.  But please try

 

Column = 
    SWITCH(
        TRUE() ,
        ISNUMBER('Table1'[STAFF_ABILITY_RESOLVE_ISSUES]), FIXED('Table1'[STAFF_ABILITY_RESOLVE_ISSUES],2),
        BLANK()
        )