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.

I have these tables:

Greetings for the day!

Greetings for the day!

Dax measure to Count number of categories where the fact value is blank(column from a different table) and replaced on date is blank(column from different table)

I currently have a cost facts table with a MonthYear column that records the fiscal month year eg. Sep FY 24 (actual september 2023), which is also the startyearmonth.

I’m new to Power Bi and I’m facing a serious problem. I have Sales table in which there is column named Moony. The table is like this:

Hi there,