Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Any help?
Solved! Go to Solution.
Fixed it by replacing Calendar[DAY] with SELECTEDVALUE(Calendar[DAY] )
Fixed it by replacing Calendar[DAY] with SELECTEDVALUE(Calendar[DAY] )
You could add a calculated column for previous day:
CALCULATE(Totals[T];FILTER(Calendar;Calendar[Day]+1=EARLIER(Calendar[Day]))
Then you can Sum this Column in a Measure and this should do the job.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
81 | |
67 | |
61 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |