Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
T-Pan
Helper I
Helper I

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 1
sdg1393
Frequent Visitor

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 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors