Forum Discussion
Multiple DateTime Columns [In UTC] - How to Show in Different TimeZone [IST]
Hi RKM ,
I created some data:
Here are the steps you can follow：
1. Use Enter data to create a Slicer Table.
2. Create measure.
Measure = MAX('Table'[Date])+DIVIDE(value(right(SELECTEDVALUE(Slice[Timezone]),1)),24)3. Result:
Select the time zone in the slicer and the date will change accordingly
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi RKM ,
I created some data:
Here are the steps you can follow：
1. Use Enter data to create a Slicer Table.
2. Create measure.
Measure =
MAX('Table'[Date])+DIVIDE(value(right(SELECTEDVALUE(Slice[Timezone]),1)),24)3. Result:
Select the time zone in the slicer and the date will change accordingly
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
This sounds very very promising. I'll give it a try shortly.
Still a question - From performance stand point, is it better doing in PBI or bringing it in from SQL (i.e. both Times in seperate columns. I am just worried I already pull lot of columns and if in SQL then I need to pull more columns per row). Probably your approach would be far better.