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.
AllisonKennedy
Community Champion
Community ChampionYou need to do this as a calculated COLUMN in the same Merge table. The formula I suggested will not work as a measure because of the way the EARLIER function is used.
I clicked by mistake the "solved" button, sorry 😕
When I tried to create the new column, I had always an error on the EARLIER and more specific the red line was under the letter L, any clue?
- AllisonKennedyCan you share a screenshot of the error? It doesn't usually provide error mid function but should hopefully be just a syntax mistake.
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)
- AllisonKennedy
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.