Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I have a problem with my profit and loss calculation. For these I have an account hierarchy with a handful of special cases. In theory, it can be booked to all accounts. However, due to the hierarchical structure, some accounts are also under accounts from the upper ones. Furthermore, individual accounts can have several different parents, and the weighting in the parents can be with different signs.
Example (1): Account A11 (level 3) is to be included in A1 (level 2) negatively and in B1 (level 2) positively.
Example (2): Account A113 (level 4) is to be posted positively. However, the value in A13 (level 3) is to be displayed as negative.
I was able to solve problem 1 with SUMX by summing up the account bookings using the row context. However, an incorrect value is displayed for the postings from A13, since A113 is positively and only gets the negative sign with A13. In the rowcontext, however, the corresponding booking is not displayed (since it has a positive weighting for the line from A113 is).
In this example, a different +/- sign should have been used since the weighting of A13 is -1.
I have enclosed all the bookings.
i am grateful for any help
Bruening
Here's one article about hierarchy handling: https://www.sqlbi.com/articles/clever-hierarchy-handling-in-dax/
and here's another one that uses the new ISINSCOPE function to simplify things:
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
Best
D
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |