Error when Appling filter to compare dates between two tables

[U156531]

I  need to calculate a result where the dates between two table are equal. I'm getting the following error. Is there another DAX formula to accomplish this? Thanks

[Anonymous]

Hi @U156531 ,

Please try to modify the measure.

result=
var max_rowdate=max('table1'[date])
return 
calculate(sum('table1'[valuea])+sum('table2'[valueb]),'table1'[date]=selectedvalue('table2'[date]))

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

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

[U156531]

This is an exemple of what I'm attempting to do.  I need to get a rolling total by month for the Result measure as below. However in my pbix I can't seem to link the dates between the tables ( it breaks other relationships)  so I'm hoping it can be accomplished in the Result measure.  

         ValueA                ValueB         Result

Jan         5                        2                 7

Feb        3                        1                 11

Mar       4                        1                 16