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.
Read the announcement for more information!
We're rolling out new Kudos Given badges. Find out how many Kudos you've given.
Get an overview of the events and great community content from November.
Find out where you can attend!