Show Values by Month_Year (Date) based on another date field

[thhmez7]

Hello,

I'd like to create a measure for Revenue that shows the value by a date field, based on another date field which I filter. 

Example: When I click on the date 17th March 2021 of modifiedon-date, the chart above should show the value of March 2021 by Est. close date.

Probably I have to use selectedvalue with modifiedon, but I'm not sure. Thank you in advance

[thhmez7 · Accepted solution]

ALready got the solution.

Inactive relationship between fields yearmonth

then create a measure like this:

Calculate( sum(revenue)

, field = Selectedvalue(field)

, userelationship('a'yearmonth, 'b'yearmonth))