Forum Discussion

jdobbins's avatar
jdobbins
Frequent Visitor
4 years ago

Accounts Receivable Aging Bucket comparison - folder data source

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.

 

 

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    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")