Need Help on using concatenated output

[rangam_s]

Hi All,

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.

[sunny_talwar]

What exactly is the problem that you are facing?

[rangam_s]

I have the cumulative MTD data with invoice dates, wherein I need to show the data for all the selected year months as Line/Bar chart.

[sunny_talwar]

So, what is the problem?

[rangam_s]

I was not getting the results for the above, however I have the answer now.

Thanks

[rangam_s · Accepted solution]

Sum({<[Invoice Date]={$(=$(vlistofMaxDates))}>}[Sales Quantity])

I got expected results with the above logic.