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.
Hi
I have a table like this
The data for actual will be from another table and keyed on the Product/Colour
What is the best method to calculate the actual ?
Thanks in advance
Solved! Go to Solution.
Hi @owenmdavies,
If the target table only has one match record, I think lookupvalue should be simple to get result.
If it has multiple records can match the conditions, you can try to sumx function.
Sample:
Calculate column Single= Lookupvalue(Target[Actual],Target[Product], Product[Product],Target[Color],Product[Color]) Total= SUMX(FILTER(ALL(Target),Target[Product]=EARLIER(Product[Product])&&Target[Color]=EARLIER(Product[Color])),[Actual])
Regards,
Xiaoxin Sheng
Hi @owenmdavies,
If the target table only has one match record, I think lookupvalue should be simple to get result.
If it has multiple records can match the conditions, you can try to sumx function.
Sample:
Calculate column Single= Lookupvalue(Target[Actual],Target[Product], Product[Product],Target[Color],Product[Color]) Total= SUMX(FILTER(ALL(Target),Target[Product]=EARLIER(Product[Product])&&Target[Color]=EARLIER(Product[Color])),[Actual])
Regards,
Xiaoxin Sheng
User | Count |
---|---|
85 | |
84 | |
71 | |
65 | |
57 |
User | Count |
---|---|
129 | |
102 | |
91 | |
83 | |
67 |