Forum Discussion

B_Caron's avatar
B_Caron
Frequent Visitor
9 years ago
Solved

Convert time zones

Good Afternoon,   Our company's managers support four different time zones seperately. I have been attempting to find a more efficient solution to converting time zones in a matrix table.   My i...
Need Help
  • v-caliao-msft's avatar
    v-caliao-msft
    9 years ago

    Hi B_Caron,

     

    Do you have multiple columns which show the time for different timezone, right?

     

    I have test it on my local environment, here is the sample steps for you reference. Sample data.

    Create a new table like below.

    Create a measure in original table.
    selectedValue =
    IF (
        ISFILTERED ( Table3[Country]) && HASONEVALUE (Table3[Country] ),
         if(LASTNONBLANK (Table3[Country], 0 )="Chinese",
       MAX(Table2[Chinese]),
       if(LASTNONBLANK (Table3[Country], 0 )="UK",
        MAX(Table2[UK]),
        MAX(Table2[US])
       )
      ),
         BLANK()
    )

    Then use this measure in your visual.

     

    Regards,

    Charlie Liao

v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
9 years ago

Hi B_Caron,

 

Do you have multiple columns which show the time for different timezone, right?

 

I have test it on my local environment, here is the sample steps for you reference. Sample data.

Create a new table like below.

Create a measure in original table.
selectedValue =
IF (
    ISFILTERED ( Table3[Country]) && HASONEVALUE (Table3[Country] ),
     if(LASTNONBLANK (Table3[Country], 0 )="Chinese",
   MAX(Table2[Chinese]),
   if(LASTNONBLANK (Table3[Country], 0 )="UK",
    MAX(Table2[UK]),
    MAX(Table2[US])
   )
  ),
     BLANK()
)

Then use this measure in your visual.

 

Regards,

Charlie Liao