Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to get same day value from previous years

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

 

DAX
measure
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    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.

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      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.