Forum Discussion
Solved
Calculate difference between Amount based on most recent and least recent date
Hello, I export event sales monthly on our clients (12 tables, combined using Append). Each table has a "name" key column. From there, I have several Amount columns. I want to show the change ...
Small edits and it worked! Thank you SO MUCH!!!!
------
UpsellTotal =VAR SelectedName = SELECTEDVALUE('Merge1'[Name])VAR FirstEvent =CALCULATE(MAX('Merge1'[Event Actual]),TOPN(1,FILTER('Merge1', 'Merged Data (2)'[Name] = SelectedName &&NOT(ISBLANK('Merge1'[Event Actual]))),'Merge1'[Export Date].[Date], ASC))VAR LastEvent =CALCULATE(MAX('Merge1'[Event Actual]),TOPN(1,FILTER('Merge1', 'Merge1'[Name] = SelectedName && NOT(ISBLANK('Merge1'[Event Actual]))),'Merge1'[Export Date].[Date], DESC))RETURNLastEvent - FirstEvent
Ashish_Excel
Solution Supplier
Solution SupplierHi,
Share the download link of the PBI file.