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:28 AM - 1:15 (or 75 minutes) = 10:13 AM.

 

 

Please see above the time frame for each carrier. Not sure is the solution should be a calculated column or metric.

 

Thanks in advance for your help!! 

 

 

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 🙂 

13 Replies

  • andhiii079845's avatar
    andhiii079845
    Solution Sage
    3 years ago

    It depands if you can do this calculation in the underlaying data. Because it is fix to the columns. You can use calculated columns. If you need to modify it while filtering "on the fly" than use DAX.

    • Pamdelorbe's avatar
      Pamdelorbe
      Frequent Visitor
      3 years ago

      Would you please show me both ways? 

       

      I try to create a calculated column but only got ERROR.

       

      Thanks, 

  • 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