Convert the relevant dates EST to CST

Anonymous — Wed, 29 May 2024 15:56:17 GMT

Hi Team,

I have power BI Report which is connected semantic model (direct query), Now the requirement is i want convert the relevant dates EST to CST.

We can achieve in power Query but we have connected though direct query hence unable to do in power query.

Any suggesttions and solutions please

Re: Convert the relevant dates EST to CST

Kaviraj11 — Wed, 29 May 2024 19:35:54 GMT

1. Create a Calculated Column

2. Account for Daylight Saving Time: Keep in mind that during Daylight Saving Time, the difference might be 2 hours instead of 1. You’ll need to account for this in your DAX formula

CST Time =
IF (
[Your Date Column] >= DATE(Year, Month, Daylight Saving Start Date) &&
[Your Date Column] < DATE(Year, Month, Daylight Saving End Date),
DATEADD([Your Date Column], -2, HOUR), // During Daylight Saving Time
DATEADD([Your Date Column], -1, HOUR) // Rest of the year
)

topic Convert the relevant dates EST to CST in DAX Commands and Tips

Convert the relevant dates EST to CST

Re: Convert the relevant dates EST to CST