Hi everyone,
I hope that someone can help me. I'm trying to use the DATEADD function, (that's sound stupid, i know) but when I try to use that. Some rows the function was aplied and others don't. Why? I don't know. I did the following validations:
1. I verified that the original column has the "Date" data type.
2. I verified that the new data type was "date" too.
3. I suposed that the issue was a confusin with day and month format, something very common in tsql datetime operations, but actually some rows with similar dates were converted and others not.
4. I have a PowerPivot with only 1700 rows by 30 columns in a laptop with 12 GB of ram.... i think that it is enough ram for this process