CALENDARAUTO not working

[Tony_iberian]

Hi Guys

I want to use the calendarauto function but it is not detecting any dates, i check everything I´m aware of but still not working

https://1drv.ms/u/s!AhnqnH5Lu1_2hslp0Fwiy9ZefodOyg?e=gK1x3h

thanks in advance!

Tony

[Rutuja_Kalbhor]

Hi,

I checked your PBI file. 

CALENDARAUTO() returns the table. And in your file you are creating measure with this function.

To resolve issue, please create new table and in query bar write CALENDARAUTO() (In front of "table" word). This will resolve your issue.

Please find below screenshot for reference. Hope this helps.

[PaulDBrown · Accepted solution]

Creating a new table with the option "New table" was throwing an error along the lines of a conflict with the name "Table". I went into Power Query and there was a table called "Table" which was empty. I deleted it, and then the new table function was working fine. I've added the Calendar Table for you. See file attached

Note: I've added fields in spanish since that seems to be the language of many of the fields. You can change the language for these date fields by changing the last expression in the FORMAT function.