Detect if a customer is present last week
Hello, I am working on a Power BI project to identify customers who fix their leaks. I receive a weekly file that I upload to SharePoint. I then use Power Query to compile the data and create a table listing customers with leaks for each week. I am trying to create a calculated column or DAX formula (or a column) to check, for each customer and week, whether they had a leak in the previous week (S-1) and the current week (S) in a visualization table. It's important to note that only customers with leaks are present in the file each week. I've been trying to solve this problem, but I'm struggling to find a solution. If anyone has encountered a similar issue, I'm open to suggestions. client id start & end date of the week leak column i've also uploaded a calendar table ! 😞
