Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Convert the relevant dates EST to CST

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 

 

"Need Help"
  • Kaviraj11's avatar
    Kaviraj11
    2 years ago

    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
    )

1 Reply

  • Kaviraj11's avatar
    Kaviraj11
    Solution Sage
    2 years ago

    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
    )