Hi! I'm a new Power BI user and was unable to find the answer to my question elsewhere. Hopefully I can explain this correctly. I want to be able to calculate an adjustments amount using two measures and a column. The column contains the following information (which is entered manually, on a monthly basis):
Total Revenue:
109000
265000
354000
511000
698000
null
null
null
null
null
null
null
That column is next to another column which separates those numbers by Month and year, for example:
Months:
July 2017
August 2017
September 2017
October 2017
November 2017
December 2017
January 2018
February 2018
March 2018
April 2018
May 2018
June 2018
Ultimately, my formula would be: Total Revenue (Column) - Total Online (Measure 1) - Total Offline (Measure 2) = Adjustments
However, I want Power BI to calculate this for each of the months so we can filter it using a Month slicer. I'm not sure whether this is even possible or whether this can be done either through using a measure or a calculated column. I tried both ways and was not able to get it to work. Power BI requires me to put something in front of the column when using it with the measures (for example, sum(Total Revenue (Column) - Total Online (Measure 1) - Total Offline (Measure 2)). By using Sum() it is not returning the result that I need for the individual months.
Extra info: When used individually, the measures and the column work well with the month slicer. The measures also work well when adding or subtracting from one another. It is only when I try and include the column with the measures that things begin to calculate incorrectly.
