Forum Discussion
Dynamic start date filter (Powerpivot)
I simply cant figure out how to create a dynamic measure, that only counts start dates, where there is at lapse of at least 3 months since the last enddate. I have a table with customers, that al...
See table below all work as expected, I think you got your Count dates formula wrong make sure you didn't mix up between < or > signs in the formula.
Hi Abduvali,
I dont have a problem with the formula - The formula works perfectly.
The problem is, that it dosent count the correct start dates. If you se my table, I have a count of two for customer 1, because there is more than 3 months (or 90 days) between the end date (04-04-2017) and the next start date (01-09-2017). In your table there is only a count of one.
Sorry if I am explaining the problem incorrectly.
Regards
Lone