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.
Solved! Go to Solution.
Hi @CD1,
Please use calculate with filter functions to instead lookupvalue, I don't think 'lookupvalue' can suitable for your requirement.
For example:
Sum from other table = CALCULATE ( SUM ( table[value] ), FILTER ( ALL ( table ), table[date] >= FIRSTDATE ( table2[date] ) && table[date] <= LASTDATE ( table2[date] ) ) )
Regards,
Xiaoxin Sheng
Hi @CD1,
Please use calculate with filter functions to instead lookupvalue, I don't think 'lookupvalue' can suitable for your requirement.
For example:
Sum from other table = CALCULATE ( SUM ( table[value] ), FILTER ( ALL ( table ), table[date] >= FIRSTDATE ( table2[date] ) && table[date] <= LASTDATE ( table2[date] ) ) )
Regards,
Xiaoxin Sheng
Hello
In the event that I want to do the same, but add the values according to some concept, how to do it
User | Count |
---|---|
86 | |
84 | |
69 | |
67 | |
55 |
User | Count |
---|---|
125 | |
100 | |
90 | |
84 | |
66 |