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.

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

Hi Greg_Deckler,

Thank you for your suggestion.

 

I cannot find the column except I have to add something like sum before the column; However, column has a string value, so sum does not work on the case.

 

Best, Qianru 

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

qsong - Use MAX or MIN

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

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

     

    Thank you.

  • 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