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,
I want to calculate the total of the sum of the various accounts numbers in the credit, provided that in the same seat is the one o varios accounts in the debit.
I have a table like this:
Thank you very much and best regards.
Solved! Go to Solution.
Hi @v-huizhn-msft,
I already solved the doubt with calculate and filters. I have made an auxiliary table with the unique values of the accounting accounts and there I calculate the data I need from each of them.
Thank you very much and best regards.
Hi @Isidro,
After research, I am still confusing about your requirement? For your example, 520000 and 170000 are in different seat, 520000+170000=690000, how to calculate the total, what's the rule? Could you please list the expected result based on the sample table?
Best Regards,
Angelia
Hi @v-huizhn-msft,
I already solved the doubt with calculate and filters. I have made an auxiliary table with the unique values of the accounting accounts and there I calculate the data I need from each of them.
Thank you very much and best regards.
Hi @Isidro,
Congratulations, you have resolved your issue by yourself. Please mark the right reply as answer. More people will benefit from here.
Best Regards,
Angelia
User | Count |
---|---|
83 | |
77 | |
71 | |
69 | |
53 |
User | Count |
---|---|
105 | |
100 | |
91 | |
79 | |
68 |