How to Convert a UTC Date Field (Date Only) to PST in Power BI (Handling DST)

[manoj_0911]

Hi Power BI Community,

I have a `CALL_DATE` field in my data model that is in **UTC** and contains only **date values** (no time component).

Since this is UTC-based, I want to **convert it to Pacific Time (PST/PDT)** properly in Power BI, taking into account **Daylight Saving Time (DST)** — so that the converted date truly reflects the PST business day.

For example:
- If `CALL_DATE = 2025-06-24` in UTC, it might still be **June 23 in PST** depending on the time of day.
- But since it's a **date-only field**, I can't directly subtract hours like I would with a datetime column.

### Example of what I tried (DAX logic inside CALENDAR):
```dax

Date =
CALENDAR(
DATE(2025, 6, 20),
MAXX('LOS_REPORT_V', 'LOS_REPORT_V'[CALL_DATE])
)

[v-achippa]

Hi @manoj_0911,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @danextian for the prompt response.

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user resolved your issue? or let us know if you need any further assistance.
If any response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @manoj_0911,

We wanted to kindly follow up to check if the solution provided by the user resolved your issue? or let us know if you need any further assistance.

If any response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @manoj_0911,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user resolved your issue?
If any response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[danextian · Accepted solution]

Hi @manoj_0911 

Power BI does not automatically account for whether daylight saving time is in effect but  you can subtract hour from a date as it is whole number and time is decimal. 

INT ( MAXX ( 'LOS_REPORT_V', 'LOS_REPORT_V'[CALL_DATE] ) - DIVIDE ( 7, 24 ) )