Error when Appling filter to compare dates between two tables

Question

I&nbsp; 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&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;,
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]))
&nbsp;
How to Get Your Question Answered Quickly - Microsoft Fabric Community
&nbsp;
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
&nbsp;
Best RegardsCommunity Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
&nbsp;
&nbsp;
&nbsp;
&nbsp;

anonymous · Answer

This is an exemple of what I'm attempting to do.&nbsp; 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)&nbsp; so I'm hoping it can be accomplished in the Result measure.&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ValueA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ValueB&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ResultJan&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;7Feb&nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;11Mar&nbsp; &nbsp; &nbsp; &nbsp;4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;16

Forum Discussion

Error when Appling filter to compare dates between two tables

2 Replies

Related content

Apple Dashboard

Table Sort , sort order , comparer

How to compare apples to apples YTD, when some months are missing sales?

Power Bi On Apple mac

Apple XML parsing with dict and keys