Showing results for 
Search instead for 
Did you mean: 
Super User
Super User

Re: Calculate Totals per Keyword



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


                '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

Re: Calculate Totals per Keyword

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