Variable Start and End Time per Country

[T-Pan]

Hello Everyone, 

I have crated a column using variables, but i have a problem set specific Start Time and End Time depending each Country. 

Business Elapsed Hours (Created to Screening) = VAR BusHoursStart = TIME(09,45,00)
VAR BusHoursEnd = TIME(18,15,00).

I want BusHoursStart to be (09,45,00) if the values of column Country are (Greece or France), and BusHoursStart (11,45,00) if values are (UK or USA). 

[sdg1393]

Not sure if I understood your problem statement correctly on how dynamic you want this to be , but as a generic - 

1. Create two custom columns 1 for start time and 1 for end time

2. sample dax for start -

Business Hours Start =

var _bushourstart1 = Time(09,45,00)

var _bushourstart2 = Time(11,45,00)

Retrun 

switch(

True(),

table[country] == "USA", _bushourstart2,

table[country] == "UK", _bushourstart2,

table[country] == "France", _bushourstart1,

table[country] == "Greece", _bushourstart2

)

3. do the same step for endtime

if you want dymamic then need to put these country and start and endtime in a master table or file then join with data table and need to change the dax field accordingly