Forum Discussion

sa100's avatar
sa100
Icon for Helper I rankHelper I
3 years ago
Solved

Master Transaction Table-Assistance

Hi, i have the following master table (example My aim is to get the followings: -Profit and loss for each product trade. it should include bonus also -I get a bonus (number of purchase items * 0.1...
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    3 years ago

    Hi, sa100 

    You can refer to this .pbix file.

     

    Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

     

    Best Regards,

    Aniya Zhang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago
For example CHW product (purchase item=2304) bought on 31/03/2020 and sold on 31/03/2022.

according to your sample data it is the other way round?

  • sa100's avatar
    sa100
    Icon for Helper I rankHelper I
    3 years ago

    correction done, thank you