Accounts Receivable Aging Bucket comparison - folder data source

[jdobbins]

Hi! I have been trying to figure out a way to find the difference betweem A/R aging buckets in my Power BI report where I have 2 files in the Folder Data Set.  I want to be able to do a comparison between each aging bucket by comparing it to the file that was ran at the end of month (EOM).  When I created the data source I created a column based on the source name and the colume A/R Aging Date will either say Current (for the most recent file) or EOM (for the previous months data).  If you see the example below, how I can compare the < 31 values, and each bucket after that? Any guidance is appreciated.

[amitchandak]

@jdobbins , Need raw data for that. Assume you have measures that works across buckets and datset.

If these files are merge in power bi and current and EOM are row values

then you can have measures like

calculate([Measure], filter(Table, table[file name] = "Current")

or

calculate([Measure], filter(Table, table[file name] = "EOM")