Date problem

[patolattari]

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!

[patolattari]

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!

[jthomson]

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?

[patolattari]

Thanks for your response, could you tell me how to create that column?

[jthomson · Accepted solution]

Press new column, enter the existing column's name, type in +1...

[patolattari]

as simple as that.

lolo thanks a lot!

[patolattari]

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!