As seen from the image above, I want to go a step further to display in the visual like so:
What I need to do is check from the first image where the Date_diff for a customer falls between 1 to 5 days. If that condition is true, I count that row as 1. At the end, I display the result against MonthYear.
This is what I am trying to achieve using DAX.
I anticipate your help
Thank youDays_Between 1st_and_Last_Purchase.pbix (389.8 KB)