12.3 How to get Month and Day Name in Power BI (Power Query) | Power BI Tutorial for Beginners

#pavanlalwani #powerbi #powerquery #businessintelligence

In this Power BI tutorial, we will learn how to find the name of day and month using Power Query. We have already loaded the table in Power Query with a column named "Date," which contains the dates. It is important to set the data type of the column as "Date."

To find the name of the day, we can add a column with the "Date and Day" option. By selecting the "Name of the Day," we can automatically retrieve all the names of the days, including Sunday, Monday, Tuesday, and so on.

Similarly, to find the name of the month, we need to go to the "Month" section and select the "Name of the Month" option. This will give us the names of the months such as January, February, March, and so on.

If you only require the first three characters from the day name or month name, you can select the respective column and go to the "Transform" tab. From there, choose the "Extract First Characters" option and set the number of characters to 3.

By following these steps, you can easily obtain the names of the days and months in Power Query and Power BI. Watch this tutorial for a detailed demonstration.
--------------------------------------------------------------------------
💼 Invest in your future with our Power BI 2023 NEW Course at an incredible 50% discount:

📚 200+ MCQs to test your knowledge.
📝 20+ Assignments for hands-on practice.
🔍 11+ Case Studies for real-world insights.
💼 5+ Industry Projects to build your portfolio.
🎓 Course Completion Certificate for your resume.
💡 Tips & Tricks to boost your skills.
🔎 5+ Industry Datasets for practical learning.

Join thousands of professionals who have transformed their careers. Enroll now at 50% off!

You can also explore our Power BI DAX 2023 course and get a 360º understanding of DAX

Invest in yourself. Become a Power BI expert. The future is yours! 💼💪"

Don't forget to use the hashtags #powerbi 📊 #powerquery 📈 #datacleaning 👨‍💼
------------------------------------------------------
Timestamps:

00:07 Finding Name of the Day 📅
00:34 Finding Name of the Month 🗓️
01:05 Extracting First Three Characters from Day Name 🌞
01:30 Extracting First Three Characters from Month Name 🗓️
01:36 Summary and Conclusion ✅

[PavanLalwani]

🚀 Calling all data enthusiasts! 💼🌟

👉 Discover the power of Power BI with our Specialization course at a jaw-dropping 50% off!


💥 Level up your analytical game and supercharge your career with the Power BI DAX course. 💯💼

[komanglayang]

Extremely concise and well explained, thank you for the video!

[sarveshgandhi]

Few videos are not there in the playlist

[InteligenciadeNegocios]

Thank you very much. Excatly what i needed

[MoinKhan-]

Hello Sir Why you hide the Dax videos and end to end project. please reupload the videos. i need to study that videos. i am following your playlist. please sir consider my request and uploa the videos or else unhide incase u hide that

[dhammadipshahare]

Dear Sir,
The data is not load ordered mannar. What is the problem sir ? And how i solve that problem. Sir pls answer this question as soon as possible.

[harshojha]

on tapping on date menu noting ARE enable except parse

[shaileynarula]

the requirement is the table name and column name of the datamodel are using ID based names.. ex., Survey_123 (for table name) and Q_1, Q_2 (for column names).. we need to change the table name and column name to a meaning full names .. is it possible to change table name and column name via transforms.. and if it is possible, can it be based on reference table where the table will have the ID based names and their corresponding meaning full names?

[funnyyoutubers]

Hi sir in my computer name of the day and name of the week is not working different names are displaying ..so please tell me the solution

[RajendraPatel.]

Sir.!! I'm Getting error while get data - Excel file- Unable to connect
"Excel workbook: the microsoft.ACE.OLEDB.12.0' provide is not registered on the local machine. The 64-bit version of the Access database engine 2010 access database engine OLEDB provider may be required to read 'WEO_Data_(Gross domestic product, current price)_2021.xlsb'." please help #Rajvlogs Delhi