Date |
17/06/2020 |
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
Type = Table.TransformColumnTypes(Source,{{"Date", type date}}),
MMYYYY = Table.AddColumn(Type, "Custom", each Date.ToText([Date], "MM-yyyy"))
in
MMYYYY
Custom |
06-2020 |
Table.AddColumn(Type, "Custom", each Date.ToText([Date], "MM-yyyy"))
, Mx2Table.AddColumn(Type, "Custom", each Date.ToText([Date], "MMM-yyyy")),
Mx3Table.AddColumn(Type, "Custom", each Date.ToText([Date], "MMMM-yyyy")),
Mx4