Fix the UTC and PST timezone issue

hello Rohit

Thanks for your reply.

Below is the Power Query M code : - let
Source = DateTimeZone.UtcNow(),
PST = DateTimeZone.SwitchZone(Source, -8),
PSTDate = Date.From(PST),
#"Extracted Date" = Date.From(PSTDate)
in
#"Extracted Date"

then used pstdate as parameter in oracle query let
PSTDateTime = DateTimeZone.SwitchZone(DateTimeZone.UtcNow(), -8),
PSTDate = DateTime.Date(PSTDateTime),
DateText = Date.ToText(PSTDate, "yyyy-MM-dd"),
Source = Oracle.Database(
"Servername",
[
HierarchicalNavigation = true,
Query =
"with cte_kiosk_dep as (#(lf)
select distinct dep.department_id, dep.department_name, dep.specialty, dep.rev_loc_id #(lf)
from hcclsc_lp.PAT_ENC enc #(lf)
join hcclsc.access_wrkf wrkf on wrkf.csn = enc.pat_enc_csn_id #(lf)
join hcclsc.clarity_dep dep on dep.department_id = enc.department_id #(lf)
where enc.contact_date >= trunc(DATE '" & DateText & "', 'year') #(lf)
and wrkf.metric_id = 9001700 #(lf)
), #(lf)
cte_days_of_week as (#(lf)
select which_days_c day_of_week, count(*) day_of_week_cnt #(lf)
from hcclsc.date_dimension cal #(lf)
left join kpbisc_grp_rivrpt.tbl_calendar_ext hol on hol.calendar_date = cal.calendar_dt #(lf)
where cal.which_days_c in (to_char(DATE '" & DateText & "', 'd'), to_char(DATE '" & DateText & "', 'd')+1) #(lf)
and cal.calendar_dt >= DATE '" & DateText & "' - 35 #(lf)
and cal.calendar_dt <= DATE '" & DateText & "' - 2 #(lf)
and (hol.calendar_date is null or hol.calendar_type <> 'Holiday') #(lf)
group by which_days_c #(lf)
), #(lf)
cte_raw_data as (#(lf)
select case #(lf)
when to_char(DATE '" & DateText & "', 'd') = cnt.day_of_week then DATE '" & DateText & "' #(lf)
else DATE '" & DateText & "' + 1 #(lf)
end as ENC_DATE, #(lf)
cnt.day_of_week, #(lf)
extract(hour from cast(enc.appt_time as timestamp)) as APPT_HOUR, #(lf)
loc.loc_name, #(lf)
cnt.day_of_week_cnt, #(lf)
count(enc.pat_enc_csn_id) as CHECKIN_CNT, #(lf)
count(enc.pat_enc_csn_id)/cnt.day_of_week_cnt as AVG_CHECKIN_CNT #(lf)
from hcclsc_lp.PAT_ENC enc #(lf)
join cte_kiosk_dep dep on dep.department_id = enc.department_id #(lf)
join hcclsc.clarity_loc loc on loc.loc_id = dep.rev_loc_id #(lf)
left join hcclsc.clarity_emp emp on emp.user_id = enc.checkin_user_id #(lf)
left join cte_days_of_week cnt on cnt.day_of_week = to_char(enc.contact_date,'d') #(lf)
left join kpbisc_grp_rivrpt.tbl_calendar_ext hol on hol.calendar_date = enc.contact_date #(lf)
where enc.contact_date between DATE '" & DateText & "' - 35 and DATE '" & DateText & "' - 2 #(lf)
and enc.appt_status_c in (2,6) #(lf)
and enc.enc_type_c not in ('121','129','1248','124') #(lf)
and to_char(enc.contact_date,'d') in (to_char(DATE '" & DateText & "', 'd'), to_char(DATE '" & DateText & "', 'd')+1) #(lf)
and (enc.copay_source_c = 3 or enc.copay_due = 0) #(lf)
and upper(dep.specialty) not in ('LAB','RAD') #(lf)
and loc.rpt_grp_seven = '14' #(lf)
and loc.loc_name not in ('PALM U','REST U') #(lf)
and emp.name is not null #(lf)
and (hol.calendar_date is null or hol.calendar_type <> 'Holiday') #(lf)
group by cnt.day_of_week, extract(hour from cast(enc.appt_time as timestamp)), loc.loc_name, cnt.day_of_week_cnt #(lf)
), #(lf)
cte_raw_data_line as (#(lf)
select dt.*, row_number() over (partition by dt.day_of_week, dt.loc_name order by avg_checkin_cnt desc, appt_hour asc) as LINE #(lf)
from cte_raw_data dt #(lf)
) #(lf)
select * from cte_raw_data_line"
]
),
#"Changed Type" = Table.TransformColumnTypes(Source, {{"ENC_DATE", type date}})
in
#"Changed Type"

I don't know what i am doing wrong, after publishing it is showing 02/12/26 which is UTC current date where according to PST it is stil 02/11/26.

Please help to fix this.

Regards