Attrition Analysis

Hi @arch.matef

I think your problem is that you aren’t using a separate date table. Best practice is to use a EDNA Date Table within your model.

here is the link
Extended Date Table (Power Query M function) - Power Query / M Code Showcase - Enterprise DNA Forum

The link that you stated is using the EDNA Date Table not the fact table dates

Make sure you mark your table as a date table.

thanks
Keith

1 Like