Forum Discussion
AlexanderAT
Helper I
Helper Inot a legal oleaut date - cannot refresh
Hello I'm having a problem refreshing my report online. Everything works fine on the desktop version where I can easily update my dataset, but when uploading it and trying to refresh I get the fo...
Hi there,
Dit you check the actual datevalues in your table? You most probably have a date before 1/1/1900 in one of the date fields in the table you're trying to load.
Kind regards,
Hans
Is there any way to convert dates before 1.1.1900 for the whole table? I have a bunch of tables with several columns including dates before 1.1.1900. Those dates come straight from ERP database and most of those cannot be changed in ERP GUI, (without manipulating the database).
Maybe some power query string? Table.ReplaceValue ?
I would use switch for that:
https://docs.microsoft.com/en-us/dax/switch-function-dax
In that scenario you could simply replace any value before or on that date and then specify what you want as an output :)
Hope that makes sense