Remove and Add filter to Single Column in Table

Hi Krish_A ,

Please try the following methods and check if they can solve your problem:

1.Create the simple tables.

2.Create the new column in the Table y.

GainLossY = CALCULATE(AVERAGE('Table x'[gain/loss]), ALL('Table Y'))

3.Create the table visual and select Edit interactions in the format pane. Drag the column into the visual.

4.Create the measure to apply the date filter.

GainLossDate = 
CALCULATE(AVERAGE('Table x'[gain/loss]), ALL('Table y'), 
            DATESBETWEEN('Table x'[Date], 
                DATEADD(LASTDATE('Table x'[Date]), -12, MONTH), 
                LASTDATE('Table x'[Date])
            )
        )

5.Drag the measure into the visual.

Best Regards,

Wisdom Wu

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