Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
Reference: Global Superstore dataset
I would like get the total quantity of returned items by year but I am getting the total quantity of returns in entire dataset as shown below:
No of returns not tabulated by year
Below shows the relationship established:
Relationship established as shown via order ID
Any help here? Thanks! I would like to know what went wrong or possible mistakes ive done.
Hi @Ed_Beach
There's no flow of relationship from DateTable and Returns tables. The DataTable affects the Orders table only thus your seeing the total count of returns regardless of the year. Does Orders have more than one row per Order ID?