What is more efficient for a calendar table?

Hi aramirez7 ,

Let's use the method of elimination.

First, you don't want to switch to a Mixed model. The defination of Mixed mode: 

---

 

For any Power BI Desktop file (a .pbix file) that contains some tables from DirectQuery and some import tables, the status bar displays a storage mode called Mixed.

 

Reference: Set the storage mode

 

---

Therefore, your model cannot contain imported tables. Then, methods 1, 3, and 4 do not meet the conditions and only method 2 does.

In addition, you can also consider building a date dimension table directly at the data source and then connect to it using DirectQuery mode, too.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.