Forum Discussion
Rolling Inner Join Sum
Hey Guys, I'm looking to do an inner join on a uniqueID from one table to another and then take the sum of a dollar amount from the other table. I want to write this as a DAX measure. So I...
Hi,
Share TableA and TableB data (in a format that can be pasted in MS Excel) and show the expected result.
Ashish_Mathur Hey, I uploaded the sample data onto my original post under *EDIT*. Thank you!
Hi,
In the FinalOutput worksheet, i understand how you got the figures in column C. How did you arrive at the numbers in column D? Show the Excel formula in those cells.
Ashish_Mathur Hey Ashish, I wrote these example values in Python, but I need to use Power BI for this particular task because I want to be able to dynamically filter visuals.
How have you arrived at the numbers in column D? What logic have you used. Unless i know the logic, i cannot translate that into DAX formulas.