Forum Discussion

codyraptor's avatar
codyraptor
Icon for Resolver I rankResolver I
9 years ago
Solved

Line up PY by Weekday vs CY by Weekday

I need help with a simple format.  Below you can see that my PY and CY dates start on the same row, but last year is WED and this year is THU.  Is there a way to offset this year from last year so th...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi codyraptor,

    The dates are coming from a calendar.

    Are PY and CY calculate columns in your calendar table? If that is the case, you should be able to use the formula below to add new calculate column in your calendar table to get the offseted CY. :smileyhappy:

    New PY = 'Calendar'[CY] + WEEKDAY ( 'Calendar'[CY] - WEEKDAY ( 'Calendar'[PY] ) )

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi codyraptor,

The dates are coming from a calendar.

Are PY and CY calculate columns in your calendar table? If that is the case, you should be able to use the formula below to add new calculate column in your calendar table to get the offseted CY. :smileyhappy:

New PY = 'Calendar'[CY] + WEEKDAY ( 'Calendar'[CY] - WEEKDAY ( 'Calendar'[PY] ) )

 

Regards

  • codyraptor's avatar
    codyraptor
    Icon for Resolver I rankResolver I
    9 years ago

    This works perfect!!  Thanks so much!!

  • codyraptor's avatar
    codyraptor
    Icon for Resolver I rankResolver I
    9 years ago

    K...Now I'm running into another issue.  When I place my PY counts in then they do not line up with the New PY dates.  The counts are still reflecting a year ago based on the chosen date.  I've tried filtering a measure by New PY date, but I'm not able to get it to work.  Thoughts?