Forum Discussion

bhavana_PBI's avatar
bhavana_PBI
New Member
8 years ago
Solved

Expression error: The name 'FORMAT' wasn't recognized. Make sure it's spelled correctly

This is my second day to Power BI, I am very new. I want to convert month name to number and I am using add custome column feature of power bi. and it gives me above error. this is what i have ...
Dashboards
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    8 years ago

    Hi bhavana_PBI,

     

    From the screenshot, you are creating a custom column in Query Editor, it will use Power Query. But what you write is DAX. If you want to add a custom column to return month value in Query Editor, please write a formula below: 

     

    =Date.Month(Date.FromText([Month Name] & " 15," & "2018"))

     

     

    Besides, the formula posted by bizbi are DAX, you can refer to this tutorial to do it: https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-create-calculated-columns

     

    Best Regards,
    Qiuyun Yu 

v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi bhavana_PBI,

 

From the screenshot, you are creating a custom column in Query Editor, it will use Power Query. But what you write is DAX. If you want to add a custom column to return month value in Query Editor, please write a formula below: 

 

=Date.Month(Date.FromText([Month Name] & " 15," & "2018"))

 

 

Besides, the formula posted by bizbi are DAX, you can refer to this tutorial to do it: https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-create-calculated-columns

 

Best Regards,
Qiuyun Yu 

  • bhavana_PBI's avatar
    bhavana_PBI
    New Member
    8 years ago

    Hi v-qiuyu-msft,

     

     

    Thanks its working for me. :smileyhappy: