Forum Discussion

Dunner2020's avatar
Dunner2020
Post Prodigy
5 years ago
Solved

Converting DAX code into M

Hi there,   I have a column which I created using the DAX function. I wanted to create the same column in the power query editor (and want to get rid of the column created using DAX).  Month Numb...
Need Help
Show and Tell
Tips and Tricks
  • VasTg's avatar
    VasTg
    5 years ago

    Dunner2020 

     

    Try the conditional column and assign your appropriate value. The below image is just an example.

     

     

    If it helps, mark it as a solution

    Kudos are nice too

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Dunner2020- I am not sure if i got this right but are you trying in power Query Editor to convert MonthName to Numbers. 

I added a new Column from Example and mapped the months, M Code generated itself was something on the lines: 

 

= Table.AddColumn(#"Renamed Columns", "Custom", each if [Month Name] = "Jan" then 10 else if [Month Name] = "Feb" then 11 else if [Month Name] = "Mar" then 12 else if [Month Name] = "Apr" then 1 else if [Month Name] = "May" then 2 else if [Month Name] = "June" then 3 else if [Month Name] = "July" then 4 else if [Month Name] = "Aug" then 5 else if [Month Name] = "Sep" then 6 else if [Month Name] = "Oct" then 7 else if [Month Name] = "Nov" then 8 else if [Month Name] = "Dec" then 9 else null, type number)

 

and i then removed the MonthName column

 

Does this help?