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 the following data, obviously the list go on and on:
Date | From | To | Amount |
1-1-2021 | A | B | $100 |
1-1-2021 | B | A | $200 |
1-2-2021 | A | C | $100 |
If I want to know whether the transactions is an inflow (money going in) or outflow(money going out) for each account, what are some ways that I can achieve that? For instance, the first transaction for person B will have an inflow of $100, and none for output. And A will have outflow of -$100 and and none for inflow.
I can't be creating all these table for each person because I simply have various people in my data. So what are the ways to achieve that?
Thanks in advance.
Solved! Go to Solution.
please see the attachment below
Proud to be a Super User!
Hi,
You may download my PBI file from here.
Hope this helps.
please see the attachment below
Proud to be a Super User!
Hello @ryan_mayu ,
Thanks for the fast response, you are a life-saver! I am really new to PowerBi, can you elaborate the logic behind this? I know that you have connect the three tables with cardinality. I just don't quite understand the inflow and outflow measure. For inflow is it like summing the Amount by individual in the "To" column?
There are 3 tables in the model. One is datetime, one is dim_customer and the last is the one you provided. Using the dim_customer to find if the customer is in the FROM column ,if so, that is an output. If the customer is in the To column, that will be an inflow.
Proud to be a Super User!
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 |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |