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.
Hi
I am building a report to show the web data week by same week last month. I have created a Calendar table and added columns to show week number and week sequence number to avoid any issue with year boundairies.
I enter the following formula, but when i table the numbers to sense check, they show the same as the current week.
Previous Period = calculate ( [Total Sessions], filter('Calendar', 'Calendar'[WeekSequenceNum] - 4))
Please help
Solved! Go to Solution.
@Stratford change your expression as below
Previous Period =
VAR sequenceNum = MAX( Calendar[WeekSequenceNum] )- 4
RETURN
calculate ( [Total Sessions], 'Calendar'[WeekSequenceNum] = sequenceNum)
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@Stratford change your expression as below
Previous Period =
VAR sequenceNum = MAX( Calendar[WeekSequenceNum] )- 4
RETURN
calculate ( [Total Sessions], 'Calendar'[WeekSequenceNum] = sequenceNum)
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Thanks Parry2k, works like a charm
When I try filter the data on a week offset to show weeks -1 to -5, ie the last 4 competed weeks. It reoves the previous period data. It also doesnt like it when i try to graph using the week commening dat on the axis.
Any thoughts?
Thanks
User | Count |
---|---|
85 | |
76 | |
72 | |
69 | |
55 |
User | Count |
---|---|
104 | |
99 | |
92 | |
78 | |
69 |