Extended Date Table (Power Query M function)

Hi @surpat,

For Time Intelligence functions to work there are some requirements, you can find them in this recent post.

Do I really need a full year in my Date table? - #2 by Melissa

Alternatively I would suggest not creating a relationship between the Date- and Fact table but using TREATAS to create that relationship virtually since the granularities between the tables don’t match.

As @Greg mentioned, if you have need of further assistance please create a new thread and provide all relevant information and details.

1 Like