Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
NewStep=Table.TransformColumns(Table.UnpiovtOtherColumns(PreviousStepName,{the name list of those columns, which is not date},"Month - Year","Amount"),{"Month - Year",Date.From})
NewStep=Table.TransformColumns(Table.UnpiovtOtherColumns(PreviousStepName,{the name list of those columns, which is not date},"Month - Year","Amount"),{"Month - Year",Date.From})
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.