topic Re: How to get same day value from previous years in DAX Commands and Tips

How to get same day value from previous years

Anonymous — Mon, 16 Mar 2020 06:54:15 GMT

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

Re: How to get same day value from previous years

Greg_Deckler — Sun, 15 Mar 2020 15:19:36 GMT

Anonymous - Sure,

Create a disconnected date table like this:

Production Dates = DISTINCT('Table'[Production Date])
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)
Now use that measure in a Filter on your table like image below

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

Re: How to get same day value from previous years

Anonymous — Mon, 16 Mar 2020 06:52:01 GMT

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.

Re: How to get same day value from previous years

Greg_Deckler — Mon, 16 Mar 2020 13:59:29 GMT

Anonymous - That's what I created.