cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
codyraptor Regular Visitor
Regular Visitor

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 the Thursday's line up.  Another words..6/1/2016 Wed will show data for PY..but CY will be blank....then row for 6/2/2016 will show PY for Thu...but CY will show 6/1 data for Thu.  The dates are coming from a calendar.  

 

Thanks!!

 

Capture.JPG

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
v-ljerr-msft Super Contributor
Super Contributor

Re: Line up PY by Weekday vs CY by Weekday

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. Smiley Happy

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

 

Regards

3 REPLIES 3
Highlighted
v-ljerr-msft Super Contributor
Super Contributor

Re: Line up PY by Weekday vs CY by Weekday

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. Smiley Happy

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

 

Regards

codyraptor Regular Visitor
Regular Visitor

Re: Line up PY by Weekday vs CY by Weekday

This works perfect!!  Thanks so much!!

codyraptor Regular Visitor
Regular Visitor

Re: Line up PY by Weekday vs CY by Weekday

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?

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 265 members 3,002 guests
Please welcome our newest community members: