Forum Discussion
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...
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])In my example
Column = if('Table'[Carrier]="JET BLUE",'Table'[time]-'Table'[time frame])
both time.
I do not understand your question 🙂
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.
In my example
Column = if('Table'[Carrier]="JET BLUE",'Table'[time]-'Table'[time frame])
both time.
I do not understand your question 🙂