Post Desktop App update - "Unable to execute DAX"

[GAS]

I have been running a fairly simple report in the desktop app without any problems. Then I ran the update this week and the next time I accessed the model I got the error "Unable to execute DAX", see attached.

The DAX line in the calendar table is - 

calendar = Addcolumns(CALENDARAUTO(),"Month Full Name",format([Date],"mmmm"))

The table has 2 columns "Date" and "Month Full Name"

Now when I run a refresh I get the following:

No changes had been made to the model prior to or since the app update. I can find no circular references.

How do I fix this error?

[lbendlin]

Avoid using CALENDARAUTO or auto date/time.

[GAS]

What should I use in place?

Manually put in the dates and months?

Sorry, beginner level Power BI here.

[lbendlin]

Use a static calendar table. Dates are immutable, no need to calculate them.

[tharunkumarRTK]

@GAS 

I would suggest you to create a date table in power query, you can use the below code and instead of harcording start and end date, you can use list.max function on the date column in your fact table.

https://forum.enterprisedna.co/t/extended-date-table-power-query-m-function/6390

I wont suggest this option considering calculated tables and columns are not good for your semantic model, but if you still want to create using DAX then you can use Calendar function

CALENDAR(MIN(FactTable[Date]), MAX(FactTabel[Date]))

Need a Power BI Consultation? Hire me on Upwork

Connect on LinkedIn

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!