Intelligent Headers DAX

Hi Anonymous 

Add custom columns in Edit queries,

et
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclTSUTI0MgaSxkaGSrE60UpOQLaJqRmQNDM1AYs4A9nmFpYwNbEA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Item = _t, #"Forcast SEP" = _t, #"Forcast OCT" = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Item", type text}, {"Forcast SEP", Int64.Type}, {"Forcast OCT", Int64.Type}}),
    #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Changed Type", {"Item"}, "Attribute", "Value"),
    #"Added Conditional Column" = Table.AddColumn(#"Unpivoted Other Columns", "Month", each if Text.Contains([Attribute], "SEP") then 9 else if Text.Contains([Attribute], "OCT") then 10 else null),
    #"Added Custom" = Table.AddColumn(#"Added Conditional Column", "YEAR/MONTH", each Text.Combine({Text.Combine({Text.From(Date.Year(DateTime.LocalNow()), "en-US"), Text.From([Month], "en-US")}, "/"),"1"},"/")),
    #"Changed Type1" = Table.TransformColumnTypes(#"Added Custom",{{"YEAR/MONTH", type date}})
in
    #"Changed Type1"

Close&&apply

Create visuals