Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
pallavi_r
Responsive Resident
Responsive Resident

MS Fabric Semantic Model - DAX Calendar Table

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

1 ACCEPTED SOLUTION
Jonvoge
Super User
Super User

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

View solution in original post

2 REPLIES 2
Jonvoge
Super User
Super User

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
Responsive Resident
Responsive Resident

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

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors