Relative Content

Tag Archive for powerbidax

DAX: Cumulative Sum of Monthly Balance (two tables)

I have two tables in power query, one has a list orders with bonus calculation for each orders (bonus is calculated in Power Query), and the second table has list of monthly payments to each sales person. Monthly payment is generally a sum of bonuses taken for a certain date. Is it added to the table manually every month for every person.