Forum Discussion
Wrong total values
Dear Community, have the following table below and receive the wrong column values. hope someone can help to fix that calculation. DATE YEAR = Time Table DATE Month = Time Table DATA 1 = DA...
First, you need to create a custom COLUMN that does the [Quantity] x [Price] math:
Data 6 COLUMN = [Data 5] x [Data 1] (assuming both of these are columns too.)
Now create your measure as:
TOTAL of Data 6 = SUM ( [Data 6 Column] )
Only DATA 1 & DATA 2 are columns, Data 3 until Data 6 are measures.
DATA 1 = DATA from Sales Report (= Total Sales Quantity)
DATA 2 = DATA from Sales Report (= Total Sales)
DATA 3 = Measure ( Sales Price YTD = DATA 2 / DATA 1)
DATA 4 = Measure (Sales Price Last YEAR = CALCULATE([Sales Price YTD], DATEADD('Time Table'[Date], -1,YEAR))
DATA 5 = Measure (DATA 4 - DATA 3)
DATA 6 = Measure (DATA 5 x DATA 1