Rolling Inner Join Sum

Ashish_Mathur Hey Ashish, appreciate all the help so far, its been very insightful.  Just 1 more question, is it possible to have slicers work with this DAX equation?  I will upload the same .PBIX file you had, but add 1 more column "SalesPerson" in the Available Table and name the table Available (2).

I want to able to create a slicer (or multiple) that will do what you've done above, but be able to slice and show their  Individual data in the Merge1 Summary table.

Thanks!

https://www.dropbox.com/s/kqtrf7kuai326np/Available%20and%20spend%20v1.pbix?dl=0 

Hi,

Share the source Excel file.

Ashish_Mathur 

Hey Ashish,

Here is the excel file:

https://www.dropbox.com/s/ycfjzjoe8ewzj13/TestExample_v1.xlsx?dl=0

As mentioned before, I would like to able to slice on the values in "SalesPerson" and "Position" but have the values in the FinalOutput if there is no slicing.

Thank you so much, I really appreciate this.

Hi,

How is it that in Tab B, there are no Sales Person and Position columns?

Ashish_Mathur 

Hey Ashish 

Yes, that is part of the issue.  I need to be able to slice on Table A (SalesPerson and Position) and after slicing, table A would inner join with Table B on ID with a 4 roll month and take the sum of Spent (Table B).  You were able to produce a solution in the previous post(s) but without slicing other columns.  Is what i'm asking possible in PowerBI?

Hi,

Unless we have those 2 columns in TabB, the end result will not make any sense.

Ashish_Mathur 

So it's not possible to be able to slice on Tab A (SalesPerson or Position) and then use the solution you had gave me in the previous post?

Hi,

Since those 2 columns are only in TabA, the calculations based on only that Table can be slicer by the two new columns.  The calculations on TabB and ratio will not be slicer because these 2 columns are not on TabB.

Hope this clarifies.