I have a Power BI file with 4 tables. Customer, Calls, Repairs and Date. I have calculated Total Calls, Previous Month Calls, Total Repairs and Previous Month Repairs. How do I create a flag to catch customers who have calls more than the previous month or Repairs more than the previous month? Repairs and Calls Tables are connected through the customer table
Power BI data model:
Power BI table:
