Forum Discussion
Subtract columns
Hello, My end goal is to make an automated reporting procedure, where I will copy/paste every month a new excel file (trial balance of each month) on a folder and then the outcome will appear on ...
It looks like you are trying to create a calculated measure. You need to do this as a COLUMN.
See attached pbix file below signature for reference on what I have done.
Sure, here is the error and the function that I used
(the error that I mentioned doesn't exist anymore, but a new one came to the surface)
The high level idea/problem that I have is that in the screenshot,
While I load each month a new excel, automatically with the power query it goes under the previous month and in order to make the final report I have to first put the values in columns by month and then calculate the changes. (so I can easily create more columns such as year,6-month,quarters KPI's etc.)