Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Solved! Go to 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
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
Thanks @Jonvoge for confirming that. I did it sql way taking all the unique transaction date. 😞
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.