
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Need Help on using concatenated output
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.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sum({<[Invoice Date]={$(=$(vlistofMaxDates))}>}[Sales Quantity])
I got expected results with the above logic.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
What exactly is the problem that you are facing?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
So, what is the problem?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I was not getting the results for the above, however I have the answer now.
Thanks

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sum({<[Invoice Date]={$(=$(vlistofMaxDates))}>}[Sales Quantity])
I got expected results with the above logic.
