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.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi qsong ,

 

Can you share the screenshot of your table and the column you want to convert.

 

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

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

Hi Anonymous,

 

I have a string column called calendar_month_key, and I want to convert it to be a numerical column called PP. As I described the background before, I am not able to do the format conversion in power query or by creating a calculated column because of the particular source connection. 

 

Currently, I am using the conditional statement for the conversion which consumes a lot of memory. So I cannot have enough space for further calculation. 

 

Thank you.