Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Solved! Go to Solution.
One way to solve this is to add the Month Number column in the query editor instead of DAX.
You can do this with a custom column like this:
Date.Month(Date.From(([Month] & " 2000")))
(Appending the " 2000" allows it to interpret e.g. "January 2000" as a date and then compute the month number for that date.)
The suggestion to do it in the query editor is a good one. Otherwise, you have two DAX options:
1. If you have another Date column in that table, use that to generate the Month Number column.
2. First create a duplicate column with Month2 = 'Account Changes 2016-2022'[Month]. Then point your switch column to the new Month2 column.
Pat
One way to solve this is to add the Month Number column in the query editor instead of DAX.
You can do this with a custom column like this:
Date.Month(Date.From(([Month] & " 2000")))
(Appending the " 2000" allows it to interpret e.g. "January 2000" as a date and then compute the month number for that date.)
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
9 | |
8 | |
7 | |
6 |
User | Count |
---|---|
14 | |
13 | |
11 | |
9 | |
8 |