File 1 - Contains Sales Data Item No - Location - Qty - Rate Value File 2 - Stock Report Item No - Location - Qty - Rate Value Wanted to create the Matrix to find the sales for last 6 month sale based on stock available in Store on the basis of Item No and Location. Pls help

Just found another video which you might be able to adopt to your last 6 months requirements. [How To Compare Time Related Insights Together With Difference Date Slicers]

How to do sumifs in Power Bi

DAX DAX Calculations

pranamg June 25, 2022, 5:39am 6

You can either use CALCULATE or FILTER Functions. You can use RELATED to bring in columns from other tables.