creating roling dates with 2 table visuals next to each other

[Karola]

I have to tables next to each other with data in it. 

what i want in the left table are the last 12 months when there is data for the second column 
then in the table to the right are the next 12 months. 

and everytime new data comes in for the customer a new month comes at the top of the left table etc etc. 

this is to easily compare data between the same month of a different year

A example of how i would have it. 

so when new data comes in, the topdate is 2022-02 and 11 months before. in the second table it should start then at 2021-02 and 11 months before. 

[v-janeyg-msft · Accepted solution]

Hi, @Karola 

In left table, you can directly use relative date in filter pane.

In right table, you need to create a measure and put it in filter pane to filter.

Like this:

Measure = 
var a=DATE(YEAR(TODAY()),MONTH(TODAY()),1)
var b=EDATE(a,-12)
var c=EDATE(a,-24)
return IF(MAX('Table'[Date]) >=c&&MAX('Table'[Date])<b,1,0)

Below is my sample.

Did I answer your question? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,
Community Support Team _ Janey

[Karola]

Nice, Thank you! I will take a look at this

[lbendlin]

In your calendar table add columns for "Same Date Last Year" , "Last Year"  etc.  Then you can use those columns to display the right table.