Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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 ...
Need Help
Show and Tell
Tutorial Requests
  • AllisonKennedy's avatar
    AllisonKennedy
    5 years ago

    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. 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

I got this type of error,

 

"A single value for column 'CumulativeTotal' in table 'Merge' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result."

 

Any ideas or suggestions?

AllisonKennedy's avatar
AllisonKennedy
Community Champion
5 years ago
You 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.
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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?

    • AllisonKennedy's avatar
      AllisonKennedy
      Community Champion
      5 years ago
      Can you share a screenshot of the error? It doesn't usually provide error mid function but should hopefully be just a syntax mistake.
      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        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)