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

Hi,

One more question:

What format time frame should be? as "time" for example 1:15 AM (1 hour and 15 minutes) or  75 minutes (duration). 

This is to the formula be able to do the calculation between the two columns and not show error. 

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

    Hi, 

     

    I think it worked!

     

    Just one more question: How can add multiple carriers to the same formula and also.. 

    If else statement?

     

    For example...

     

    Column = if('Table'[Carrier]="JET BLUE" and IBERIA and CONDOR,'Table'[time]-'Table'[time frame])...

     

    Thanks!

     

  • andhiii079845's avatar
    andhiii079845
    Solution Sage
    3 years ago

    Yes like this: 

    Column = if('Table'[Carrier] in {"JET BLUE, "Test"},'Table'[time]-'Table'[time frame])