Need Help for PowerPivots

[Farhan Younas]

Hi,
dear all, anyone can please help me.
i have made 3 workbooks in excel for my 1) sales, 2) remittance and 3) Targets

my sales table contains
date, month, day, year, dealer code, dealer name, regions, product purchased, product value

my remittance table contatins
date, month, day, year, dealer code, dealer name, region, remittance

my targets tables contain
month, year, sales targets and remittance targets.

i am unable to make connections, if i want to make connection for say date, dealer code, region, it gives error that "Relationship can not be created because each column contain duplicate value. select atleast one column that contains only unique value"

need your help and guidance to learn something new and awesome

 

[rahulshewale1]

Hii @farhaan,'


Could you provide sample data and descried output ?


Regard
Rahul shewale

 

[Farhan Younas]

Dear Rahul Shewale
i have attached a workbook in my request. attaching again

 

[rahulshewale1]

hii @Farhan Younas ,

i have open excel file but it is empty noting data in file.

 

[Farhan Younas]

please go to powerpivot, manage
you will get 2 sheet

one is sales
other is remittance

 

[Farhan Younas]

@rahulshewale1 attached is my files which i was trying to get in PP

 

[rahulshewale1]

hii @ Farhaan

could you please provide 3 target file


so i will try on that.


regard
Rahul shewale

 

[Farhan Younas]

leave targets, i just want to make connections in these 2 files, thanks for ur support

 

[rahulshewale1]

@Farhan,


pfa attached data model sheet.

for details watch below video

 

[GraH - Guido]

i am unable to make connections, if i want to make connection for say date, dealer code, region, it gives error that "Relationship can not be created because each column contain duplicate value. select atleast one column that contains only unique value"

It just means your "lookup" tables or "dim(ension)" tables contain double items (key column) which may not be the case in PP/data model.
You should normalize your date first.

 

[Farhan Younas]

Dear @rahulshewale1 i cant see any video and file is empty which you attached with message.
@GraH - Guido can you please share detail, data is normal. there is no double column. if a product is sold to many customers or single customer many times this is the normal database. need your detailed help.

 

[rahulshewale1]

Dear farhan,


please check now.

 

[GraH - Guido]

@GraH - Guido can you please share detail, data is normal. there is no double column. if a product is sold to many customers or single customer many times this is the normal database. need your detailed help.[/quote]
Not double column, a double key. E.g. if both tables contain region, and region value is repeated in both tables, PP will not allow the relationship.
You need a third table which contains unique values of regions, then build the relationship.