Forum Discussion
Date problem
Hi guys, i'm kind of new with PBI and i need some help, importing from sharepoint, there's one column with dates, and even though it's OK on the source, (checked), PBI takes and shows it as the day before, Nov 29th instead of 30th. I tried changing the region but the error remains...
Any idea of what yould I do? if i can't fix it, hoy could I create a new column with the previous column date plus one day?
Thanks!
Press new column, enter the existing column's name, type in +1...
5 Replies
- patolattariRegular Visitor
Hi guys, i'm kind of new with PBI and i need some help, importing from sharepoint, there's one column with dates, and even though it's OK on the source, (checked), PBI takes and shows it as the day before, Nov 29th instead of 30th. I tried changing the region but the error remains...
Any idea of what yould I do? if i can't fix it, hoy could I create a new column with the previous column date plus one day?
Thanks!
- jthomsonSolution Sage
For the second question, having a calculated column reference the existing date column and adding 1 should be straightforward. Not sure why the first one would crop up - possibly it's some sort of time zone issue where it's interpreting the date as datetime and then shifting the time zone to UTC or something which affects the date as a result?
- patolattariRegular Visitor
Thanks for your response, could you tell me how to create that column?
- jthomsonSolution Sage
Press new column, enter the existing column's name, type in +1...