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.
Hi Team
I'm using this formula to count the sum of all Terminated staff up to a specified date. However, I would like to change the measure so that it looks 1 year earlier from the selected date.
I think there needs to be a change made after “MAX<.......
I.e DATEADD(Table [Calendar],-1,YEAR)
But something that works.
Current formula
Thanks!
Solved! Go to Solution.
May be this one
= VAR maxdate = MAX ( Calendar[Date] ) VAR mydate = DATE ( YEAR ( maxdate ) - 1, MONTH ( maxdate ), DAY ( Maxdate ) ) RETURN CALCULATE ( [count terminated], FILTER ( ALLSELECTED ( Calendar[Date] ), Calendar[Date] < mydate ) )
May be this one
= VAR maxdate = MAX ( Calendar[Date] ) VAR mydate = DATE ( YEAR ( maxdate ) - 1, MONTH ( maxdate ), DAY ( Maxdate ) ) RETURN CALCULATE ( [count terminated], FILTER ( ALLSELECTED ( Calendar[Date] ), Calendar[Date] < mydate ) )
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 |
---|---|
105 | |
97 | |
79 | |
66 | |
62 |
User | Count |
---|---|
145 | |
113 | |
105 | |
85 | |
65 |