Forum Discussion
Current Selections Box Date Hierarchy
Hello, I've been trying to show a filter selction in a "Current Selection" box I made. I can get it to work with a filter I use for state, but I cannot get it to work for a date hierarchy filter...
This partially works, but I get a year and month for every record listed that matches year and month. I'm looking for a way to only show one month year, so it guess like:
DateCreateSelection =
IF (
ISFILTERED ( 'tbl_Data'[DateCreated] ),
"State:" & UNICHAR ( 10 )
& CONCATENATEX ( DISTINCT ( 'tbl_Data'[DateCreated] ), DISTINCT(Year('tbl_Data'[DateCreated] & " - " & Month('tbl_Data'[DateCreated])), ", " ),
"No filter applied"
)
The issue is I cannot DISTINCT the year and month.
v-easonf-msft
Community Support
Community SupportHi, Anonymous
If it is convenient, can you share some saample data for further research?
Best Regards,
Community Support Team _ Eason