New Item Sold By each Sales person

[arif_sqit]

Dear All,

I need to make a report using these four tables where My management can see the new item sold by each sales person using sales person name as a filter and month and year as a filter...

I have made connection from Salesperson master (Code) to Sales-Inv_header(Salesperson code)

Sales-Inv-Header (Doc No) to Item-Ledger-Entry (Doc No)

Item master (Item code) to Item ledger entry (item code)

Date tables [Date] to Item master [Item Creation Date])

since we don't have any conenection between sales peron and item master, so filtering salesperson doesn't show any filteration item sales

how to resolve this,

please help out

Item master table

item ledger entry

Sales-Invoice Header Table

Salesperson Master Table

[arif_sqit]

thank you sir,

New item means, when that is created in Item master, now they want to see that selecting sales-person name (filter), year & month filter when & how much that items (qty) are sold in that perticular period... 

i don't know how this sales person filter will work for item-master (Items)

[amitchandak]

@arif_sqit , what is the definition of a new item, based on that we can use Sales-Invoice Header and Item ledger. Assume they two join

we try an approach like this

Customer Retention Part 2: Period over Period Retention :https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-2-Period-over-Period-Retenti...

or

Customer Retention Part 3: Period Of Stay – Cohort Analysis: https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-3-Period-Of-Stay-Cohort-Anal...

Above need to converted into this need