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,
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!
Yes like this:
Column = if('Table'[Carrier] in {"JET BLUE, "Test"},'Table'[time]-'Table'[time frame])