powre bi report builder , concatenation

[Anonymous]

I did not see a power bi report builder category so posting here, my apologies 

I have a report that i built in power bi report builder (.rdl). My report header should say something like this

data between "date1" and "date2"  (date1 and date2 are columns in the dataset)

however, the concatenation & is not working, how do i concatenate a text followed by these 2 date columns ?

[v-eachen-msft]

Hi @Anonymous ,

Maybe this link will help you:

https://docs.microsoft.com/en-us/power-bi/paginated-reports/report-builder-expression-examples#functions

And you could also go to Report Server community for further help.

[mwegener]

Hi @Anonymous ,

try to use placeholders and  aggregated values (min / max)

https://docs.microsoft.com/en-us/sql/reporting-services/report-design/formatting-text-and-placeholders-report-builder-and-ssrs?view=sql-server-ver15

https://docs.microsoft.com/en-us/sql/reporting-services/report-design/report-builder-functions-max-function?view=sql-server-ver15

https://docs.microsoft.com/en-us/sql/reporting-services/report-design/report-builder-functions-min-function?view=sql-server-ver15