Forum Discussion
Filter on date column with SQL ibm db2
Hi, I have a large table which I would like to filter dynamically based on a date column. I have an orderdate column which has the format YYYYMMDD from the IBM db2 database. However, if I woul...
Hello,
by the error it seems that there is a value in the column that cannot be converted to Date and that's what giving you the error.
Why don't you try importing the table with the column as it comes and trying to transform it in DAX?
If you do so, and need help, i will be glad to help you!