Convert Year or Month Year column to Date - Power BI Desktop Tips and Tricks (29/100)

How to generate the Date Column From Year Column using Power Query
If you don't have the Date column in the source table but you have only year or Month Year column then follow this video.
How to create date column From Month Year column in Power Query
How to create the Date Column from Year column in Power Query

#PowerBI #Datecolumn #Yearcolumn

Complete Playlists

BI Developer - Complete Reference - Playlist
BI Architect - Complete Reference - Playlist

[guillermodeory]

I was going crazy trying to solve this particular issue by myself. Thanks a lot for the concise explanation!!

[eleanortay]

Thank you for the great info, especially the simulation of errors in date and how to specify a desired day & month. I have subscribed to your channel too! 👍

[chinyeregift]

This video was very useful. This is my first time to comment on Youtube video

[leonardoromero]

Is there a way to do it without adding a column? thanks 😊

[lakshmanbsn]

Hi Sir, I have scenario how to create Balance of Year, YTD & FY values based on month selection in slicer

[zxyzxyzyzyugfd]

thanks for the video. My issue is, i have 2 columns in the first month number (1 to 12), and in the second year (2021, 2022). I want to create a third column with full end of month date 31.01.2021, 28.02.2021, 31.03.2021.... How to do it ?

[abdulqadeerkamangar]

Can we change month and year text as well, for ex 12020 1 is Jan followed by year?

[jananiingarshal]

Very Useful. Let me know if you have any courses for PowerBi Services? Im based out of Chennai.

[Bobbi]

Thank you so much you ate a life saver.

[jaishri]

If I have no. column for month and I want to convert in 5 like may and 1 like Jan...how?

[navaneethkumar]

Hi Nag Very Good morning

Could you please make a video on data to publish for last 13months using Dax

[kiran]

hi bro pls tell me how to create a Date calculated column with a Date datatype using year, month nd day ?

[nadiyamodi]

How to show monthlyweekly and yearlyweek sir

[swapoj]

Hi Nag, Need your advice on the below scenario.
I have data file that need to upload daily in power bi. The file has to keep the historical data as well as new data.
The file only have month and year in the time column.
So the first day I upload the file with the first day date and time by adding first date with DDMMYYYY in one colum.
Now I want to do incremental load the data next day, but on the next day file the when I upload it's change the date on next date in the time column and change the dates in historical and new data with next date date. When I upload the next day power bi create a duplicates as all the historical data was added with next day dates.
Please advice how I can solve this issue.
Thank you.

[sravankumar]

Hi Nag This Logo Is not Looking good, Please change. Previous one is better than this.