Forum Discussion
CALENDARAUTO not working
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
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.
2 Replies
PaulDBrownCommunity Champion
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.
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.
