I have a dataset that contains 3.2m rows of accounts receiveable data. My users would like a slicer/filter that allows them to select the date they’d like to run the report and the result would something similar to below.
Each row in my dataset contains (amongst other columns) the due date, the clearing date (ie. date settled), the customer number and the value of the invoice. The data to be displayed would be all invoices with a due date prior to the date selected that have no clearing date or a clearing date after the date selected. I’ve managed to achieve this with a series of measures and filters but having issues with the report taking a long time to refresh and when running from the service we get an “out of memory” error if not enough fields are filtered. I’ve attached an example file with data in question and our current methodology. Anyone know how I can achieve the same result in a more efficient manner?
Aged Trial Balance Example Data.pbix (113.8 KB)