cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Super User
Super User

Re: Calculate Totals per Keyword

@corvada

 

Sorry for late reply.

 

It works like this

 

1) The Filter part filters the table and grabs only rows with a) same customer number b) non blank key words c) where date is before the current row date

 

FILTER (
                'Table Invoices',
                'Table Invoices'[Customernumber] = EARLIER ( 'Table Invoices'[Customernumber] )
                    && NOT ( ISBLANK ( 'Table Invoices'[Keyword] ) )
                    && 'Table Invoices'[Invoicedate] < EARLIER ( 'Table Invoices'[Invoicedate] )
            )

 

2) TOPN filters this (already filtered) table further and grabs the row with the maximum date

 

3) from above steps we have a single row of all the Columns in the Table...But we need only "Key Word" column. So I used an ITERATOR to grab it...We could also have used other ITERATORS like MINX or MAXX.....or other techniques like selectcolumns as well

 

corvada Member
Member

Re: Calculate Totals per Keyword

Thank you very much, @Zubair_Muhammad, it clear things up for me. Thumbs up, :-)