Forum Discussion

Fairuz's avatar
Fairuz
Copper Contributor
May 23, 2022
Solved

Power Query: Increase date by one day

Hi,   I am almost done transforming my data in Power Query but I am stuck at this problem. Screenshot:   I am trying to make the dates in the column Date to increase by one day if the time ...
excel
  • Martin_Weiss's avatar
    Martin_Weiss
    May 24, 2022

    Hi Fairuz 

     

    you could add a custom column with this formula:

     

    =if [Time.1]= #time(12,0,0) then Date.AddDays([Date],1) else [Date]

Martin_Weiss's avatar
Martin_Weiss
Bronze Contributor
May 24, 2022

Hi Fairuz 

 

you could add a custom column with this formula:

 

=if [Time.1]= #time(12,0,0) then Date.AddDays([Date],1) else [Date]

Fairuz's avatar
Fairuz
Copper Contributor
May 27, 2022

Martin_Weiss Thank you! This works fine.

Resources