How to get same day value from previous years

[Anonymous]

Hello all,

I have two tables one with a production value from previous 5 years and a datetable.

I would like to show a same day same month value in every year compared with cuurent day.  The values are producing each hour everyday as 24 values per day.

Example:

ProductionDate              Production value

01/02/2016                       1232

04/05/2017                       12465

31/08/2017                       5757

27/11/2018                       3432

15/10/2018                       5766

04/05/2019                       5767

01/02/2019                       5322

01/02/2020                       2789

Visual:

Value on current date: 01/02/2020 compared from previous years

01/02/2020   :   2789

01/02/2019   :   5322

01/02/2016   :   1232

Would be a great help if one could help how to get this?

Thank you.

Best regards,

Ravali

[Greg_Deckler · Accepted solution]

@Anonymous - Sure,

1. Create a disconnected date table like this: 
   Production Dates = DISTINCT('Table'[Production Date])
2. Create a measure like this: 
   Measure =
   VAR __CompareDate = MAX('Production Dates'[Production Date])
   VAR __Date = MAX('Table'[Production Date])
   RETURN
   IF(DAY(__Date) = DAY(__CompareDate) && MONTH(__Date) = MONTH(__CompareDate),1,0)
3. Now use that measure in a Filter on your table like image below

I have attached a PBIX if it helps. Below my sig.

[Anonymous]

Hi @Greg_Deckler ,

Thank you for your reply. I have made a little unclear question. 

I need to visualize current day value and previous years on same day. Could you please help me in this? 

It would be a great help.

Thank you.

Best regards,

Ravali.

[Greg_Deckler]

@Anonymous - That's what I created.