Forum Discussion

Pamdelorbe's avatar
Pamdelorbe
Frequent Visitor
3 years ago
Solved

Time calculation with DAX or conditional column

Hi everyone!   I would like to obtain CTA time based on the carrier's subtraction time frame. For example, if the carrier is Jet Blue, subtract 75 minutes or (1 h 15 mm) to the specified time. 11...
Need Help
  • andhiii079845's avatar
    andhiii079845
    3 years ago

    It try it with a calculated table (not in Power Query Editor), it works with time and datetime:

    Column = if('Table'[Carrier]="JET BLUE",'Table'[time]-'Table'[time frame])
  • andhiii079845's avatar
    andhiii079845
    3 years ago

    In my example 
    Column = if('Table'[Carrier]="JET BLUE",'Table'[time]-'Table'[time frame])
    both time.
    I do not understand your question 🙂 

andhiii079845's avatar
andhiii079845
Solution Sage
3 years ago

Please post some example data with the table function, no screenshot please

Pamdelorbe's avatar
Pamdelorbe
Frequent Visitor
3 years ago

Hi, 

Let me show you:

1. I try to create a conditional column. For example. if Carrier = Jet Blue, Time Frame = 75 (minutes). 

Then created a custom colum to subtract time_frame from real time (Hora ATD):

 

 

Here is the Error: 

 

 

I think might be the data type I selected for time_frame. 

Please let me know iyour comments. 

Thanks, 

 

 

2. Then I tried to subtract the time frame from Time column. But the result is the time itself and not the subtracted calculated time. 

 

 

Then