Prefered SKU per posname with conditions

Anything related to PowerPivot and DAX Formuale
Zaoka
Posts: 1
Joined: Wed Feb 26, 2020 5:26 pm

Prefered SKU per posname with conditions

Postby Zaoka » Wed Feb 26, 2020 5:36 pm

Hi ,

I'm trying to combine two tables with power pivot to see prefer SKU per Posname according to State and RetailCategory, but I'm doing something wrong

1. table is Base with columns Posname, Entity, RetailCategory, Sales person ID
2. table is prefer SKU with colmns [u]Entity[/u], [u]RetailCategory[/u], SKU name, days

My result should be single Power pivot table in tabular form

Posname, Entity, RetailCategory, Sales person ID, SKU name, days

I created a helper column in both tables with a combination of State & RetailCategory as single column and "key" table with all combination of State & RetailCategory . Then I load it all to power pivot , created relation and result is wrong , I simply get all possible SKUs and states per posname

https://ibb.co/Bnv3yzR

Excel example

https://drive.google.com/open?id=1w9Cfv ... WUJVhTEA7C

Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 1 guest