How to get only one matching month and year of other date column

[Evanooruvan]

I have two date column,

one column has month-year and another column is weekend-dates, like below image

i want to have only one matching month and year of the month column, like below

the issue is starting of month and end of month sometimes present in previous month as highlighted in first image,

can someone help me get the result of 2nd image, any date is fine as long it is only one date matching the month column, so i could use it in  my slicer.

@grey  @FreemanZ @Jihwan_Kim  any help please. thank you

[Anonymous · Accepted solution]

Hi @Evanooruvan 

You can refer to the following solution.

Sample data 

Create a measure

Measure =
VAR a =
    MINX (
        FILTER (
            ALLSELECTED ( 'Table' ),
            EOMONTH ( [wk_end_dt], 0 ) = EOMONTH ( MAX ( 'Table'[Date] ), 0 )
        ),
        [wk_end_dt]
    )
RETURN
    IF ( MAX ( 'Table'[wk_end_dt] ) = a, 1, 0 )

Then put it to the visual filter.

Output

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ritaf1983]

Hi @Evanooruvan 
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...