Rolling 12 months data

Hi parry2k , 

https://docs.google.com/spreadsheets/d/1lQI0l-Ahz30XkgPx7jABx_Cy8V9usJb6AJzelZX04PI/edit?usp=sharing

This is my sample dataset.

So, basically I have a dataset that contains :
A- it is a primary key contains several IDs
B - Date time stamp (mm/dd/yyyy)  format 
C - this contains 2 types of option yes or no 
D- contains 4 different products  (toy , train , bus , car ) 

Also, I have made a DATE TABLE in POWER BI.

Basicall my requirement is , I have made a slicer from my DATE TABLE in my report , so I want whenever i select a date from my slicer, then I want to display the count of my IDs (from column A ) of one year back on a line chart. (Also, due to some UI Constraint i can't use relative slicer , i just have the option to select a single date from the DATE TABLE slicer)
For eg: If I select 5 may 2020 in DATE TABLE slicer, then I want to display the count of IDs ( from column A ) in a line chart , from MAY 2019 to APRIL 2020 (Also, due to some UI constraint , I don't have the option of using the relative date slicer, I just have the option of using the normal date slicer)

I hope you understand my problem statement.
Thanks ! 

Hi @parry2k ,

https://docs.google.com/spreadsheets/d/1lQI0l-Ahz30XkgPx7jABx_Cy8V9usJb6AJzelZX04PI/edit?usp=sharing

Here's my sample dataset.

So, I basically have a dataset that contains:
A- is a primary key containing multiple iDs
B - Date stamp format (mm/dd/yy)
C - contains 2 types of yes or no option
D- contains 4 different products (toy, train, bus, car)

In addition, I have created a TABLE OF FECHAs in POWER BI.

Basicall my requirement is , I've done a slicer of my date table in my report, so I want every time I select a date from my slicer, then I want to show the count of my iDs (from column A) from a year ago in a line chart. (Also, due to some UI restriction I can't use relative slicer, I only have the option to select a single date from date slicer)
For example: If I select 5 May 2020 in the TABLE DATE segmentation, then I want to display the ID count (from column A) in a line chart, from MAY 2019 to APRIL 2020 (Also, due to some UI constraint, I don't have the option to use relative date segmentation , I only have the option to use normal date segmentation)

I hope you understand my problem statement.
Thank you!

Hi @parry2k ,

https://docs.google.com/spreadsheets/d/1lQI0l-Ahz30XkgPx7jABx_Cy8V9usJb6AJzelZX04PI/edit?usp=sharing

Here's my sample dataset.

So, I basically have a dataset that contains:
A- is a primary key containing multiple iDs
B - Date stamp format (mm/dd/yy)
C - contains 2 types of yes or no option
D- contains 4 different products (toy, train, bus, car)

In addition, I have created a TABLE OF FECHAs in POWER BI.

Basicall my requirement is , I've done a slicer of my date table in my report, so I want every time I select a date from my slicer, then I want to show the count of my iDs (from column A) from a year ago in a line chart. (Also, due to some UI restriction I can't use relative slicer, I only have the option to select a single date from date slicer)
For example: If I select 5 May 2020 in the TABLE DATE segmentation, then I want to display the ID count (from column A) in a line chart, from MAY 2019 to APRIL 2020 (Also, due to some UI constraint, I don't have the option to use relative date segmentation , I only have the option to use normal date segmentation)

I hope you understand my problem statement.
Thank you!