Dynamic Text from Excel file by selecting period and operating unit

[Anonymous]

Hi,  I am working in a DAshboard with has comments based on the Operating Unit and dates selected. It is working. However, it brings just the max/ min or the comments. Having said that, the filter that applies is the selected period, but ou is just bringing North America.

comments_iniciatives = if(not([SlicerCheck_OU] = 0), calculate(max('comments_QTR'[SPECIAL INICIATIVES]), filter('comments_QTR', [yr_qtr] = [max_SP])), "Please select a BU for the comments to be displayed")

Thanks for your help!

[Anonymous]

The problem I need the comments filters by period selected and the OU slicers.

[amitchandak]

@Anonymous , Based on wthat I got. You can use concatenatex

concatenatex('comments_QTR', 'comments_QTR'[SPECIAL INICIATIVES], ", ")

That will all comments comma separated

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.