Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello!
Can someone help me write this correctly? It's about entering a value from an earlier date. I'm trying to do it using "EARLIER" but it doesn't work for me.
Solved! Go to Solution.
Hi @bjurek ,
Here are the steps you can follow:
1. Create calculated column.
Calculated Column1 =
MAXX(
FILTER(ALL('Table'),
'Table'[Shop]=EARLIER('Table'[Shop])&&
'Table'[Date]<EARLIER('Table'[Date])),[Date])
2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @bjurek ,
Here are the steps you can follow:
1. Create calculated column.
Calculated Column1 =
MAXX(
FILTER(ALL('Table'),
'Table'[Shop]=EARLIER('Table'[Shop])&&
'Table'[Date]<EARLIER('Table'[Date])),[Date])
2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @bjurek
Please clarify further the part that says "skip product B".
Please try
Previous Product =
MAXX (
TOPN (
1,
FILTER (
CALCULATETABLE ( ALLEXCEPT ( 'Table', 'Table'[Shop] ) ),
'Table'[Date] < EARLIER ( 'Table'[Date] )
),
'Table'[Date]
),
'Table'[Product]
)
User | Count |
---|---|
69 | |
43 | |
21 | |
21 | |
14 |
User | Count |
---|---|
124 | |
41 | |
39 | |
28 | |
24 |