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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.