Forum Discussion

qsong's avatar
qsong
Icon for Helper II rankHelper II
6 years ago
Solved

Convert string to number in DAX Function

Hello Community,   I connected to the source data through the online mode of the AAS model in Power BI, so I am not able to change formats of the datasets using the conventional ways (power query, ...
Need Help DAX measure
  • qsong's avatar
    qsong
    6 years ago

    Finally I used VALUE(MAX()) to refer the column names, and it works for me.

     

    Thank you.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

qsong - Use MAX or MIN

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Greg,

 

I need to convert 123-45-789-0 is kind of string format data to number format ,could you please help me .

 

I need to logic to get additional values result 

For example,

 

 AI        Col-A    Col-B   Result

 A         123.     123.       Equal

 A         123.                  Extra 

 

I need to get extra for same document A