Forum Discussion
Solved
Create Measure based on different row (date)
Hi guys, I am trying to create a report on Power BI but can't pin the right way although the goal seems very simple. Here is my sample data below. I want to create a measure that will do the ...
NextDay Totals = CALCULATE ( SUM ( 'Table'[Quantity] ), DATEADD ( 'Calendar'[Date], +1, DAY ) )
NextDay Totals = CALCULATE ( SUM ( 'Table'[Quantity] ), DATEADD ( 'Calendar'[Date], +1, DAY ) )
Sean I believe your solution is close to what I am looking for.
I have written the formulas as :
Spoiler
NextDay Total = CALCULATE(SUM('Product'[Quantity]),DATEADD('Product'[Date],1,DAY))
Note that I am using the same table for Quantity and Date. It works like a charm with the current sample, I have tried to add one product C with non following date for test:
It looks fine at first
But when I filter C I get this message
Fair enough, I have tried to add a calendar table relating to Product table and changed the measure to:
Spoiler
NextDay Total = CALCULATE(SUM('Product'[Quantity]),DATEADD('Calendar'[Date],1,DAY))
The measure looks like a simple Sum(Quantity)