Forum Discussion

T-Pan's avatar
T-Pan
Icon for Helper I rankHelper I
2 years ago

Variable Start and End Time per Country

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

 

 

1 Reply

  • sdg1393's avatar
    sdg1393
    Frequent Visitor
    2 years ago

    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