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 🙂 

Pamdelorbe's avatar
Pamdelorbe
Frequent Visitor
3 years ago

Yes. Hora ATD is a real time and depending the carrier I would like to subtract 90, 75 or 30 minutes in order to obtain a new colum with the subtracted exact time.  

 

Thanks, 

andhiii079845's avatar
andhiii079845
Solution Sage
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])