Forum Discussion

axel_BI's avatar
axel_BI
Icon for Helper I rankHelper I
6 years ago

Comparing Day by Day delivered/waste

Hello everybody,   following case:   I have the data of multiple Point of Sales. Each day, they get delivered a variety of articles. Let's say newspapers. I know which POS receives which amount o...
Need Help
MFelix's avatar
MFelix
Icon for Super User rankSuper User
6 years ago

Hi axel_BI ,

 

You need to add a filter statment to your calculation something similar to:

 

Sum Waste Following Day = CALCULATE([Sum Waste];Filter(ALL(Transaktions[Date]);Transaktions[Date] = DATEADD(Transaktions[Date];1;DAY))

 

When just adding the dateadd function the row context remains the same as in your dsate so you will not pick up any values.