Power BI - Last Updated Table

Last Updated Table.m

let
    Source = #table(type table[Refresh Date Time=datetime], {{UTC_to_MountainTime(DateTimeZone.RemoveZone(DateTimeZone.UtcNow()))}}),
    #"Add Date Only Col" = Table.AddColumn(Source, "Refresh Date", each Date.From([Refresh Date Time])),
    #"Add Date Month Name" = Table.AddColumn(#"Add Date Only Col", "Month Name", each Date.MonthName([Refresh Date])),
    #"Add 'Refresh Date Time (UTC)'" = Table.AddColumn(#"Add Date Month Name", "Refresh Date Time (UTC)", each DateTimeZone.RemoveZone(DateTimeZone.FixedUtcNow()))
in
    #"Add 'Refresh Date Time (UTC)'"

UTC_to_MountainTime.m

(datetimecolumn as datetime) =>

let

date = DateTime.Date(datetimecolumn),
time = DateTime.Time(datetimecolumn),
firstSundayOfNovember = Date.StartOfWeek(#date(Date.Year(date), 11, 7), Day.Sunday),
SecondSundayOfMarch = Date.StartOfWeek(#date(Date.Year(date), 3, 14), Day.Sunday),

isSummerTime =	(date = SecondSundayOfMarch and time >= #time(1,0,0))
	        or
		(date > SecondSundayOfMarch and date < firstSundayOfNovember) 
		or 
		(date = firstSundayOfNovember and time >= #time(1,0,0)),


timeZone = (7 - Number.From(isSummerTime))*-1,

MDT = 
            DateTime.From(date) 
            + #duration(0,Time.Hour(time),Time.Minute(time),Time.Second(time))  
            + #duration(0, timeZone, 0, 0)

in
    MDT

// Source: https://community.powerbi.com/t5/Power-Query/Convert-Date-Time-in-UTC-to-Local-Time-with-Daylight-savings/td-p/789919