Forum Discussion

Quinnie2017's avatar
Quinnie2017
Icon for Helper II rankHelper II
5 years ago
Solved

My Day Week Year (DWY) formula needs improvement!

THE SITUATION: Based upon good advice from Anonymous from this post I created a DWY column:   DWY = WEEKDAY('Day Key'[Business Date])*10000000 + WEEKNUM('Day Key'[Business Date])*10000 + YEAR(...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Quinnie2017 ,

     

    You could try using the measure

     

    Same Week Day Last year =CALCULATE([Sales], dateadd('Date'[Date],-364,Day))

     

    Let me know if this worked for you.

     

    Cheers

     

    CheenuSing

Robbief's avatar
Robbief
Icon for Helper II rankHelper II
3 years ago

Just ran into this one myself......  Did you come up with a solution for it?

Anonymous's avatar
Anonymous
Not applicable
3 years ago

HI Robbief ,
The solution is in the thread itself. Check it out.

 

Cheers

CheenuSing

  • Robbief's avatar
    Robbief
    Icon for Helper II rankHelper II
    3 years ago

    O wow - This works for leap years too.....