The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
Hello,
I have data coming as UTC timezone and will need to covert it. As far as I search, I can only use the following formula:
RL_LocalTime = FORMAT(salesorders[createdon]+TIME(1,0,0),"General Date")
That means I will need to re-visit the formula when I enter into Winter time. Do we have any other solutions for this?
Thanks,
Ricky
Hi@ rickylee
you may try to use IF() function to add a column like below:
RL_LocalTime =IF(Mon is Summer time, FORMAT(salesorders[createdon]+TIME(1,0,0),"General Date") ,FORMAT(salesorders[createdon]+TIME(2,0,0),"General Date"))
Best Regards,
Lin
User | Count |
---|---|
158 | |
109 | |
96 | |
84 | |
75 |
User | Count |
---|---|
157 | |
137 | |
131 | |
81 | |
61 |