This content has been marked as final. Show 5 replies
I am using aggregation function to generate the maximum transaction date in each month and concatenating it to populate the list of available maximum date.
Background: I have a cumulative data set wherein all the sales will be accumulated till the maximum invoice date in that particular month. Now, I need to populate the sales quantity for each month.
vlistofMaxDates=concat(aggr(max([Invoice Date]),YearMonth) ,',')
if(sum(Match([Invoice Date],$(vlistofMaxDates)))=>1,[Sales Quantity])
Note: Month end is not the maximum date in every-month and not every Maximum transaction date in that month has maximum sales. I using this as chart measure.
Please help me in resolving this issue.