Forum Discussion
in PowerQueryEditor, Convert DateTime to YYYMM
Unfortunately, this leaves you with a text field. If you want it to be useable as a date:
From the Power Query Editor, add a new column as beginning of month:
Table.AddColumn(#"Filtered Rows", "dtStartOfMonth", each Date.StartOfMonth([dtRunDate]), type datetime)
From the Data View, format the date using yyyy-mm:
dtRunMonth = FORMAT(OLAPJobHistory[dtStartOfMonth],"yyyy-mm")
This worked for me:
= Table.AddColumn(dbo_OLAPJobHistory, "dtRunMonth", each DateTime.ToText([dtRunDate],"yyyyMM"))
Thank you
Unfortunately, this leaves you with a text field. If you want it to be useable as a date:
From the Power Query Editor, add a new column as beginning of month:
Table.AddColumn(#"Filtered Rows", "dtStartOfMonth", each Date.StartOfMonth([dtRunDate]), type datetime)
From the Data View, format the date using yyyy-mm: