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


View solution in original post

corvada Member

Re: Calculate Totals per Keyword

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

View solution in original post

Helpful resources

Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 220 members 2,766 guests
Please welcome our newest community members: