Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Column cleaning with DAX

Hi guys, 

Can you please help me with column cleaning.  It has two data types ( int and text) and some blanks.  I just want to keep them  integers.  Can you please help me writing Dax Querry. 

 

Many Thanks, C

Column A
12
10
20
A
B
C
50
 
  • smpa01's avatar
    smpa01
    4 years ago

    Anonymous  you can write a measure like this

     

    Measure =
CALCULATE (
    MAX ( 'Table 1'[Column A] ),
    FILTER (
        'Table 1',
        IFERROR ( CONVERT ( 'Table 1'[Column A], INTEGER ), -999 )
            = IFERROR ( 'Table 1'[Column A] * 1, 0 )
    )
)

     

     

     

2 Replies

  • smpa01's avatar
    smpa01
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Anonymous  you can write a measure like this

     

    Measure =
CALCULATE (
    MAX ( 'Table 1'[Column A] ),
    FILTER (
        'Table 1',
        IFERROR ( CONVERT ( 'Table 1'[Column A], INTEGER ), -999 )
            = IFERROR ( 'Table 1'[Column A] * 1, 0 )
    )
)

     

     

     

    • smpa01's avatar
      smpa01
      Icon for Community Champion rankCommunity Champion
      4 years ago

      Anonymous  did you have a chance to look into the solution I provided?