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 🙂
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.
Would you please show me both ways?
I try to create a calculated column but only got ERROR.
Thanks,
