Forum Discussion
MP_123
10 years agoMicrosoft Employee
time period
hi everyone
i created page filter on Date field. for example one week
how can i show on my report the "report period"? to show on the report the including dates in the report
thanks!
You can create a measure that returns text - something like this
FORMAT( MIN(Dates[Date]), "mm-dd-yyyy") & " to " & FORMAT( MAX(Dates[Date]), "mm-dd-yyyy")
This will return something like "03-24-2016 to 04-04-2016"
5 Replies
- austinsenseImpactful Individual
You can create a measure that returns text - something like this
FORMAT( MIN(Dates[Date]), "mm-dd-yyyy") & " to " & FORMAT( MAX(Dates[Date]), "mm-dd-yyyy")
This will return something like "03-24-2016 to 04-04-2016"
- MP_123Microsoft Employee
thank you
but in whice visualization i display this measure? i mean how to display
thank you!
- austinsenseImpactful Individual
Card?