Sum records that are the previous year to slider date selection

[Anonymous]

Hi

Does enyone know a way that I can show the sum of a value based on a previous year to users slider selection (e.g. user selects 1st Oct 2020 to 4th Nov 2020 I would like to calculate 1st Oct 2019 to 4th Nov 2019). The results must also be able to be filtered by dimensional selections and displayed in table with dimensional records as the rows.

This is based on a star schema data structure with date, fact and other dimensional tables (fact can be joined to date via key or date fields).

I have previously tried posting the specific challange I am facing with no luck so I thought I'd see if someone can help me with the concept first and then I will design my solution around it.

Any help would be greatly appreciated.

For those that are interested, this is my original post. https://community.powerbi.com/t5/Desktop/Prior-year-sales-based-on-slider/m-p/1763135#M691720 

[amitchandak · Accepted solution]

@Anonymous , Try a measure like this with date table, slicer should be on date table

Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Year))

[Anonymous]

@amitchandak Thank you this is the solution.

I have actually tried this before but had the table join Cross filter direction set to both. Changing them to Single cracked it.