I have two tables
Calendar, with days
Totals, with Total (let's say sales) per day
Created in table Totals the following measures:
T = SUM(Totals[sales])
PreviousDay = SELECTEDVALUE(Calendar[Day]) -1
TPreviousDay = CALCULATE(Totals[T], FILTER(ALL(Calendar), Calendar[DAY] = [PreviousDay]))
But the TPreviousDay comes always blank...
If I replace [PreviousDay] by a value, it returns the correct value.
Go to Solution.
Fixed it by replacing Calendar[DAY] with SELECTEDVALUE(Calendar[DAY] )
View solution in original post
You could add a calculated column for previous day:
Then you can Sum this Column in a Measure and this should do the job.
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!