Forum Discussion
Help with Power Query Date Table returning Error for some columns
Hi, I have this script for a date table but the "Offset" columns are returning error. The script was sourced from Radcad site and the only change I made to the script was input my 'api key' and cha...
I believe I have fixed the issue by having a play with the day offset filters and seems to be working as it should. Thanks for your time and help.
The URL doesn't work. It returns this:
I would not refer to any free website for a critical report.
If you want a dynamic date table that can handle timezones and doesn't rely on websites, try Creating a Dynamic Date Table in Power Query and Add a Refresh Time Stamp To Your Power BI Reports — ehansalytics which will walk you through the process and show you how to build a table to help with DST issues.