Forum Discussion
MS Fabric Semantic Model - DAX Calendar Table
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
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
