cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Arif270182 Regular Visitor
Regular Visitor

Date Mapping - comparison (current year vs last year)

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 SALES TABLE.PNGI have data for 2018 & 2019 by per day hereMAPPING TABLE.PNGthis is mapping of dates - 2019 - 2018

Looking for support 

5 REPLIES 5
Super User
Super User

Re: Date Mapping - comparison (current year vs last year)

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. Smiley Happy


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Highlighted
Arif270182 Regular Visitor
Regular Visitor

Re: Date Mapping - comparison (current year vs last year)

Super User 

 

 

 

Community Support Team
Community Support Team

Re: Date Mapping - comparison (current year vs last year)

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.

Date-Mapping-comparison-current-year-vs-last-year

2. Create a measure.

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

Date-Mapping-comparison-current-year-vs-last-year-2

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support Team
Community Support Team

Re: Date Mapping - comparison (current year vs last year)

Hi @Arif270182,

 

Could you please mark the proper answers as solutions?

 

 

Best Regards,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Arif270182 Regular Visitor
Regular Visitor

Re: Date Mapping - comparison (current year vs last year)

Hi Support 

 

Apologies for late reply - No this one still not working Smiley Sad 

 

will share more details soon