
Alan Sidman
Steamboat Springs, CO
Member
Members

Forum Posts: 123
Member Since:
October 18, 2018
October 18, 2018


Riny van Eekelen
Örnsköldsvik, Sweden
Moderator
Members

Trusted Members
Moderators
Power BI

Trusted Members
Moderators
Power BI

Forum Posts: 382
Member Since:
January 31, 2022
January 31, 2022

I created a small example in the attached file, where the following code adds a column with corrected dates for dates after today.
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Date", type date}}),
#"Added Custom" = Table.AddColumn(#"Changed Type", "Corrected Date", each if Date.IsInYearToDate([Date]) then [Date] else Date.AddYears ([Date], -1))
in
#"Added Custom"
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 170
Currently Online: Riny van Eekelen, Ivan Kulubya, Vijay Vardhan
Guest(s) 39
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1431
Anders Sehlstedt: 845
Velouria: 574
Purfleet: 412
Frans Visser: 346
David_Ng: 306
lea cohen: 213
A.Maurizio: 202
Aye Mu: 201
Jessica Stewart: 185
Newest Members:
Vicky Otosnika
Abhishek Singh
Kevin Sojourner
Kara Weiss
And Woox
Armani Quenga
moshood bello
annelies b
James1989
lucy gilmour
Forum Stats:
Groups: 3
Forums: 24
Topics: 6045
Posts: 26523
Member Stats:
Guest Posters: 49
Members: 31492
Moderators: 2
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Riny van Eekelen
© Simple:Press —
