Date Mapping - comparison (current year vs last year)

[Arif270182]

Good Evening 

I am looking support to understand how we i can map date for day to day comparision 

example :- 01st Jan 2019 mapped to 01st Jan 2018 ; 02nd Jan 2019 mapped to 03rd Jan 2018 (Same day - same week) 

i have table build for date mapping - All i need is to build connection between table to show me Current year vs Last Year 

below are my 2 tables I have data for 2018 & 2019 by per day herethis is mapping of dates - 2019 - 2018

Looking for support 

[Greg_Deckler]

Having a little trouble understanding exactly what you are trying to do here but if you have 2018 in one table and 2019 in another table then you should be able to connect your CurrentYearDate to your DOB in 2019 table and LastYearDate to your DOB in your 2018 table. Is that what you are going for or do you have 2018 and 2019 dates in a single table? If that is the case, then you could form 2 relationships and the use USERELATIONSHIP in your calculations to determine which relationship to use.

Looks like you are trying to do same store sales or something similar. I would suggest ditching the mapping entirely and letting machine learning do the the job for you. 🙂

[Arif270182]

 Greg_Deckler Thank you for prompt reply 

let me explain you more clear 

First table in picture has entire data from 2018 & 2019 

Table no 2 has date mapping 2019 vs 2018 

Now i am looking support for performance comparision example

yesterday i.e. 02nd Jan 2019 Sales 100,000 which is positive 125 % growth as Last year i.e. 03rd Jan 2018 80,000 SALES

Is that clear enough ? 

[v-jiascu-msft]

Hi @Arif270182,

Could you please mark the proper answers as solutions?

Best Regards,

[Arif270182]

Hi Support 

Apologies for late reply - No this one still not working 😞 

will share more details soon 

[v-jiascu-msft]

Hi @Arif270182,

I was going to recreate the date table. But I found @Greg_Deckler's idea is great due to you already have the mapped dates. Please download the demo from the attachment. 

1. Create two relationships.

2. Create a measure.

Measure =
DIVIDE (
    SUM ( FactTable[Value] ),
    CALCULATE (
        SUM ( FactTable[Value] ),
        USERELATIONSHIP ( DateMapping[LastYearMapDate], FactTable[DOB] )
    )
)

Best Regards,
Dale