Forum Discussion
Subtract columns
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)
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.
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.)
Great, problem solved! The file that you sent me helped a lot! Thanks!! 🙂
- You're welcome!