Forum Discussion

Tony_iberian's avatar
Tony_iberian
New Member
3 years ago
Solved

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=g...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    3 years ago

    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.

PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
3 years ago

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.