cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Arif270182
Helper II
Helper II

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 I have data for 2018 & 2019 by per day hereI have data for 2018 & 2019 by per day herethis is mapping of dates - 2019 - 2018this is mapping of dates - 2019 - 2018

Looking for support 

5 REPLIES 5
Greg_Deckler
Super User
Super User

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. 🙂


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

Super User 

 

 

 

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.

Hi Support 

 

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

 

will share more details soon 

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.

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors
Top Kudoed Authors