Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Error when Appling filter to compare dates between two tables

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            
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

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.

 

 

 

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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