Date Table Creation

DAX DAX Calculations
1

Nisha

Is it a good approach to create the date-table with below DAX or we simply need to create a Date-Table which was explained in “Ultimate Beginners Guide to DAX” video ie. Parameter Query?
DAX :
CustomizedDateTable = CALENDAR(MINX(‘active_users’,[date]),MAXX(‘active_users’,[date]))

(active_users is my FACT table)

1 Like
2

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
3

Hi @Nisha , did the response provided by @DavieJoe help in solving your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query.

4

Hi @Nisha we’ve noticed that no response was received from you.

We just want to check if you still need further help with this post?

In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.