Forum Discussion

ringocheng618's avatar
ringocheng618
Frequent Visitor
5 years ago
Solved

Money Inflow and Outflow Question

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 w...
Need Help
ringocheng618's avatar
ringocheng618
Frequent Visitor
5 years ago

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?

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    5 years ago

    ringocheng618 

    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.