Forum Discussion

ScottA's avatar
ScottA
Frequent Visitor
5 years ago
Solved

Get results from dynamically calculated tables

Hi I’m having trouble doing this task dynamically in PowerBI.   My data table is a list of flights with information such as flight number, from/to, depart/arrive times.   Flights Flight Numb...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    ScottA , Try a measure like this to related arrival time with bucket

    calculate(countx(filter(Flights, Flights[arr time] >= Min(TimeBucket[from]) && Flights[arr time] <= max(TimeBucket[to])),[Flight Number]), values(flight[Flight Number]))

     

    You might need to copies time bucket to get this for departure time

amitchandak's avatar
amitchandak
Super User
5 years ago

ScottA , Try a measure like this to related arrival time with bucket

calculate(countx(filter(Flights, Flights[arr time] >= Min(TimeBucket[from]) && Flights[arr time] <= max(TimeBucket[to])),[Flight Number]), values(flight[Flight Number]))

 

You might need to copies time bucket to get this for departure time