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
Did you try to use a variable on your formula?
var _earlierWeek = Query1_VW[Week_Begin]
If I answer your question, please mark my post as a solution, this will also help others.
Please give Kudos for support
.Tomas Santandreu Polanco |Principal Business Intelligence Consultant
www.designmind.com
EARLIER gives you access to the previous filter context. If you call it in a CALCULATE statement it will give you access to the filter context before the calculate statement is executed. You would be able to nest the calls....but EARLIER is not designed to give you access to the previous row.
Help when you know. Ask when you don't!
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 |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
36 | |
33 | |
18 | |
18 |