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.

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.