Setting custom Calendar messes up formulas

[Miron]

I am building custom Calendar in PowerBI.
For Month number I used the following formula:

=dDate[Date].[MonthNo]

I got month numbers. After creatin several more collumns I marked the table as a date table and all collumns turned to errors.

The error message i got from PowerBI: Column referebce to 'dDate' cannot be used with a variation 'Month' because it does not have any.
Similar error I got for Year column but with 'Year'.

So I rebuilt the formular in other manner that worked.

=MONTH(dDate[Date])

Any idea why PowerBI don't like the first syntax?

 

[Matt Allington]

The first syntax is using the inbuilt hidden calendar tables. When you mark as date table, the inbuilt hidden calendar tables are removed. That’s what caused the change.