DATE Selection Before 2 Month After 2 Month

[bilalkhokar73]

Dear Team,

I have the date table and Amount from the sales table 

When I select a date of let's say 15 April 2021 then I need that Column should show me Before 2 month Sales and After 2-month sales  (i.e., 15 Feb to 15 April sales I need ) and 16 April to 15 June
If I select a  Month instead of a date,  let's say I selected July 2021 it then it should show me May-June and July-August sales.

[mahoneypat]

Here is a measure expression that shows one way to do it.  You can adapt it and use MAX('Date'[Date]) to get the Next Two Months measure.

Two Months Before =
VAR mindate =
    MIN ( 'Date'[Date] )
RETURN
    CALCULATE (
        [Total Sales],
        FILTER (
            ALL ( 'Date' ),
            'Date'[Date] >= EDATE ( mindate, -2 )
                && 'Date'[Date] <= mindate
        )
    )

Pat