Dynamic Dates for Textbox

[aishak12]

Hello All,

I am currently using this formula to show a textbox of the selected date on my filter.

CurrentMonth = SELECTEDVALUE(Query1[TransDate].[Month])

However, when selecting more than one month the textbox shows "BLANK". Is there an option to show the multiple selected months  for example: ("January - March")  or ("January, February, March) 

[v-yiruan-msft · Accepted solution]

Hi @aishak12 ,

You can create a measure as below:

Measure =
CONCATENATEX (
    ALLSELECTED ( 'Query1'[TransDate].[Month] ),
    'Query1'[TransDate].[Month],
    ","
)

Best Regards

[vanessafvg]

you can try something like this

test =
CONCATENATEX ( VALUES ( query1[TransDate] ), [TransDate], "," )

[aishak12]

Thank you for the suggestion, I attempted this and see all the dates used. However I only want to see the months used in the filter 

[vanessafvg]

did you try it with the month?

[aishak12]

Would you ellaborate more, im sorry not too advanced on DAX

[vanessafvg]

dont worry, sorry you can't use month in that context, let me come to you