Forum Discussion
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...
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])RETURNIF(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.
- Create a disconnected date table like this:
Greg_Deckler
Community Champion
Community ChampionAnonymous - 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])RETURNIF(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.
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_DecklerAnonymous - That's what I created.