Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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!!
Solved! Go to Solution.
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.
New PY = 'Calendar'[CY] + WEEKDAY ( 'Calendar'[CY] - WEEKDAY ( 'Calendar'[PY] ) )
Regards
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.
New PY = 'Calendar'[CY] + WEEKDAY ( 'Calendar'[CY] - WEEKDAY ( 'Calendar'[PY] ) )
Regards
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?
This works perfect!! Thanks so much!!
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |