Forum Discussion

nick9one1's avatar
nick9one1
Icon for Helper III rankHelper III
4 years ago

filtering data from dynamic measure with filter selection

I have a two tables    1. Meeting Dates 2. Submitted values The submitted values have a month and year columns. The meeting dates are a single date.  When I select a meeting date in the slic...
Need Help
v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, nick9one1 ;

You could create a new table as slicer.

Then create a flag measure.

flag = IF(EOMONTH(MAX('Table'[Date]),0)=EOMONTH(MAX('slicer'[Date]),0),1)

apply it into filter.

The final show:


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.