Forum Discussion
Forecasting future costs by month?
I am trying to present a matrix that shows total cost per location for equipment from June 2023 to May 2024. Here is a sample of the type of data I have. The real data has a lot more info than th...
I know one way of doing this is manually buy adding a column with the month year in my Excel file, duplicating it all 12 times for each month and going from there. There are some obvious drawback besides effeciency, higher potential manual error, etc. I was hoping there was a dynamic way of doing this? Maybe through Power Query M or is this something that is not possible?