Convert the relevant dates EST to CST

[Anonymous]

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 

[Kaviraj11 · Accepted solution]

Hi

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
)