MS Fabric Semantic Model - DAX Calendar Table

[pallavi_r]

Hi Everyone,

I need create this DAX calendar table using Calendar(Min(Transaction[Date])), Max(Transaction[Date])))

How can I do this in MS Fabric Semantic Model, I can see only option to create measure. Dax table option I cannot find anywhere.

Please advise.

Thank you,

Pallavi

[Jonvoge · Accepted solution]

Hi pallavi_r

I assume that you are creating a Semantic Model with Direct Lake storage mode?

In this case, you are unfortunately right that this can't done via DAX.

You may seek alternative approaches:

1. If your Semantic Model is built on a Warehouse, you could create your Calendar Table using SQL (I've had good results getting Copilot / ChatGPT to help me with this), referencing your other tables for Min and Max dates to be used.

2. If you are using a Lakehouse, you could do the same as above but with a Notebook.

3. Third alternative, and maybe most familiar to you if you are used to Power BI, is to use a Dataflow Gen2, and use Power Query to generte the table, and save it in your Lakehouse or Warehouse.

When the table has been created in your Lakehouse or Warehouse, you can use it in your semantic model.

_____________________________________________________
I hope my comment was helpful.
If your question was answered, please mark your post as 'Solved' and consider giving me a 'Thumbs Up'.
Find me on LinkedIn, Sessionize, or my blog Downhill Data

[pallavi_r]

Thanks @Jonvoge  for confirming that. I did it sql way taking all the unique transaction date. 😞