Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
User | Count |
---|---|
42 | |
28 | |
24 | |
20 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |