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 

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

qsong , are you using live connection? Otherwise, you can simply change the data type to the number and it should work as long as all values in the column are number

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

    I am using the live connection. So I cannot use power query to make the change.