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

Hora ATD has the datatype "datetime", right? Or "time"?

Pamdelorbe's avatar
Pamdelorbe
Frequent Visitor
3 years ago

HI, 

Only time (see below). 

 

 

I have a doubt about this formula:

[DateTime] + #duration(0,10,0,0))

 

Since time frame relies on a conditional statement (carrier). How can I specify time frame based on the carrier?

 

Thanks,