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 dear community,
I have a very big table with all financial movements, and if it's a movement between companys of the same group, I have a column named interco that marks the movement as "Company A - Company B".
When I select all movements from the column A, and column B less "Company A- Company B" I should obtain the ideal result, but due to some mismarked movements or other things, I have smalll diferences.
So my goal is to calculate the balance, and then the excess/defit in EBITDA should became the opposit or a cost or a revenue:
Date | Cat | Value | Company | InterCom |
01/10/2023 | Sales | 10 | A | A-B |
01/10/2023 | Cost | -10 | B | A-B |
01/10/2023 | Sales | 5 | A | A-B |
As you can see, here you have an increase in sales, so If I select only company A or company B, I don't want to change anything but if I select the interco, I should add a row with the oposite signal e this case a cost in the company B.
I know it's quite confused but any suggestion is super apperciated
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
90 | |
79 | |
61 | |
60 | |
58 |
User | Count |
---|---|
151 | |
113 | |
99 | |
80 | |
72 |