Forum Discussion

Arentir's avatar
Arentir
Resolver III
9 years ago
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 ...
Need Help
  • Sean's avatar
    Sean
    9 years ago
    NextDay Totals =
CALCULATE ( SUM ( 'Table'[Quantity] ), DATEADD ( 'Calendar'[Date], +1, DAY ) )
Sean's avatar
Sean
Community Champion
9 years ago

Replace Product[Date] in the Table Visual with Calendar[Date] :smileyhappy:

Arentir's avatar
Arentir
Resolver III
9 years ago

Thanks Sean it was simple as that!