Date Table Creation

Hi @Nisha

I’d say the best thing to do would be to use the awesome EDNA Date Table created by Melissa de Korte. Link below.

Extended Date Table (Power Query M function) - M Code Showcase - Enterprise DNA Forum

Here is the link to the training video which shows you how to created dynamic start and end dates for your date table.

Setting Up A Dynamic Startdate And Enddate For Power Query Date Tables (enterprisedna.co).

Thanks

DJ

1 Like