How do I convert month format in Power BI?

0 votes
I need to create multiple reports with different sets of data. The main problem is that the data is in raw format and I need to filter it out first and then create my reports. In order to do so I need to change some formats in dates so that it can easily be sorted.

How do I do this with the help of Power BI Desktop?
Mar 26 in Power BI by Phalguni
• 970 points
67 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
0 votes

Hi,

This can easily be done using DAX functions in Power BI

You can use this function to perform the above operation

MonthName = ‘Table Name’ [Date] . [Month]

Or,

MonthName = FORMAT (DATE (1, [NUM] , 1) , “MMM”)

Note: DAX is not a programming language, its a formula based language

answered Mar 26 by Avantika
• 1,460 points

Related Questions In Power BI

0 votes
1 answer

How do I format the KPI in Power BI

format the KPI by selecting the paint ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 36,730 points
44 views
0 votes
1 answer

How do I know who in my organization has a Power BI account?

You can view the Azure Active Directory ...READ MORE

answered Oct 15, 2018 in Power BI by Hannah
• 14,080 points
28 views
0 votes
1 answer

How Do I Find Power BI users that have signed in

If you are a tenant admin, and ...READ MORE

answered Oct 15, 2018 in Power BI by Hannah
• 14,080 points
23 views
+2 votes
2 answers

How do I undo something in Power BI?

Hi Lina, It depends what you are trying ...READ MORE

answered Oct 17, 2018 in Power BI by Machdata
• 340 points
1,216 views
+3 votes
2 answers

Combine tables in Power BI

You can also achieve this using a ...READ MORE

answered Oct 5, 2018 in Power BI by lina
• 8,100 points

edited Oct 11, 2018 by Kalgi 98 views
0 votes
1 answer

Power Bi Dax Table

You need to wrap the numbers in ...READ MORE

answered Oct 5, 2018 in Power BI by Kalgi
• 36,730 points
47 views
0 votes
2 answers

Power BI Dax Multiple IF AND Statements

HI I have Column Patient 12 13 14 15 18 IN Patient=12, 13 Out ...READ MORE

answered May 22 in Power BI by VNK
4,665 views
0 votes
1 answer

Distinct count filtered by condition using Power BI Dax

Try this, it should work: DistinctCountActiveMonths = CALCULATE( ...READ MORE

answered Oct 5, 2018 in Power BI by Kalgi
• 36,730 points
2,926 views
0 votes
1 answer

How do I use Python scripts in Power BI?

Hi, You can create interactive reports out of ...READ MORE

answered May 2 in Power BI by Avantika
• 1,460 points
55 views
0 votes
1 answer

How do you create a link visual in Power BI?

You can easily create a link between ...READ MORE

answered Mar 8 in Power BI by Avantika
• 1,460 points

edited Mar 9 by Avantika 44 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.