Forum Discussion
Time calculation with DAX or conditional column
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 try it with a calculated table (not in Power Query Editor), it works with time and datetime:
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 🙂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])