Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Dunner2020
Post Prodigy
Post Prodigy

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 Number = SWITCH([Month Name],
"April",1,
"May",2,
"June",3,
"July",4,
"August",5,
"September",6,
"October",7,
"November",8,
"December",9,
"January",10,
"February",11,
12
)
 
When I applied the same formula in power query editor I got the following error:

However, I got the following error:

myasir_0-1600227470953.png

Could anyone help me in converting DAX code into M language?

 

1 ACCEPTED SOLUTION
VasTg
Memorable Member
Memorable Member

@Dunner2020 

 

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

 

image.png

 

If it helps, mark it as a solution

Kudos are nice too

Connect on LinkedIn

View solution in original post

4 REPLIES 4
v-diye-msft
Community Support
Community Support

Hi @Dunner2020 

 

If the above posts help, please kindly mark it as a answer to help others find it more quickly. thanks!

If not, please kindly elaborate more.

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.
NamishB
Post Prodigy
Post Prodigy

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?

 

amitchandak
Super User
Super User

VasTg
Memorable Member
Memorable Member

@Dunner2020 

 

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

 

image.png

 

If it helps, mark it as a solution

Kudos are nice too

Connect on LinkedIn

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.