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 conn...
"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
    )

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
)