List filtering and counting duplicates

[andresomza]

Hello,

I have a problem, I can't find a solution. I have an APP in which I keep track of the different flights that we operate with the company I work for. In the same list I have a SLICE with a filter that shows me the flights of the previous week, with their details, schedules, etc.

The problem is that I can't find a formula to make a list of the airports we have visited (source column).

This column is made up of places, which are duplicate values. I need to make a list and count how many times we visit that place. For example:

Miami: 5 flights this week

Mexico City: 10 flights this Week

Los Angeles: 2 flights this week

I'll use this information with an excel file. I need to auto build a table (with <<start: the list>> <<End>>

[TeeSee1]

One idea.

A separate table with the following columns

• ID: UNIQUEID()
• Airport:  One Airport per Week value
• Week: Week for which you want to get counts of each destination
• Visit Count: a VC with the expression like

COUNT(
 SELECT(
  flights table[any col],
  AND(
   [destination] = [_THISROW].[destination],
   You need week filter using [_THISROW].[Week] and a col in flights table with flight date here
  )
)