Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help with returns Dax scenario



I have a


Date table - Full Date & Season Code

Sales Table - order number  & order date

Returns Table - order number & return date & return reason


I am wanting to count the number of orders that have a return with specific reason lost in transit with season code 'aw20'


So the date in the returns table isnt relevent the join is between


Sales.orderdate and Date.fulldate  

Sales.ordernumber and Returns.OrderNumber


I guess the question is in powerbi how do I only pull the back the orders placed in a specific timeperiod with returns?


Thanks in Advance.







Not applicable


Hi, @Anonymous 

Sample data and expected result will better help us understand what you want.

Please provide some simplified data so it will be easier to suggest possible approaches.


Best Regards,
Community Support Team _ Eason

Helpful resources

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Dev Camp Session 22 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!