Forum Discussion

twowaysyellow's avatar
twowaysyellow
Frequent Visitor
3 years ago

Calculating Supported Trips Based on Area and Direction in Power BI

I have a table with information about trips, and whether a trip is supported or not based on whether it takes place within a certain area. A trip is supported either by the departing (starting) area,...
Need Help
whitch's avatar
whitch
Icon for Resolver I rankResolver I
3 years ago

In Power Query create a 'Trips' table by grouping your base table on Trip_id and area_id, and summing the [from_supported] and [to_supported] columns.  Add a [trip supported] column which is 0 if [from_supported] and [to_supported] are both 0, and is 1 otherwise.  Now group on area_id and sum [trip supported].