Forum Discussion
OFFSET Optimization for Large Dataset
I have a measure that is working as expected to determine the sum of the Total YTD Sales in the previous row in the Sales table when used on a partition (1 company key for 1 year('Product Sales'[Date...
amitchandak - Thank you for your reply! In this case I am reversing YTD data into the change since the previous record by pointbreak sorted by date and Total YTD Sales amount. I think that I need to somehow filter the measure to only iterate on the selected company_key while ignoring all other filters in the visual as the formula works with just one company_key of data, but I have not been able to do this.