excel - PowerPivot Relations - error while creating -
i m trying create relation between database , table created avoid using vlookup formula in excel. error. want link account daily report names. can tell me how solve or why getting error? thanks
as error message states, have either duplicate entries or blanks in "daily report names" column. note when bring data power pivot trims it, items different in excel due trailing spaces become duplicates in pp. check not bringing through blank rows in dataset. highlight number of rows on excel sheet below dataset , delete entire rows.
Comments
Post a Comment