Group Colum with data of Different Months

[Anonymous]

Hi all,

Sorry if I'm asking a simple question as I'm fresh to power BI.

I have a data set of about 4,000 expenses accounts and colums of their respective amounts from 2020/01 till 2023/01, shown as follow.

I would like to group all colums into two colums, "Month" & "Amount", is there anyway to do it? Thanks in advance for your replies.

[wdx223_Daniel · Accepted solution]

NewStep=Table.TransformColumns(Table.UnpiovtOtherColumns(PreviousStepName,{the name list of those columns, which is not date},"Month - Year","Amount"),{"Month - Year",Date.From})