All Dates 1 day out compared to the Source SP List.

[StuartSmith]

Ive noticed that all the dates in the Bi Report are 1 day behind the SP List dates.  I could create a +1 date column for each date column, but there are lots, so looking for a better solution.

Thanks in advance.

[v-stephen-msft · Accepted solution]

Hi @StuartSmith ,

Here's my idea.

Go to Power Query, select all date columns and click "Unpivot Columns".

Add a custom column to add 1 day.

Remove the [Value] column and pivot as follows.

As you can see, all dates are added 1 day.

Pivot columns - Power Query | Microsoft Learn

Unpivot columns - Power Query | Microsoft Learn

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

[StuartSmith]

Thanks for your input Stephen, I will give it a go, but as the report contains multiple date columns, I would be nice to know why this is happening and fix, instead of having the fix every date column.

[StuartSmith]

Anyone with any ideas?