Power BI: How to Always Show Current Week vs. Prior Week 📅 Automatically!

How to create a Power BI report that always shows Current Week vs. Prior Week automatically!
00:00 Question: How to Always Show Current vs. Prior Week Automatically
01:24 Understanding the Current Week in Calendar Table
04:02 Using Current Week to Create Automatic DAX Measures
Download the file from web.learnpowerbi.com/download
For Questions: www.LearnPowerBI.com/question
For Training: www.LearnPowerBI.com/training
================================
#PowerBI #PowerBIQandA #PowerBIQuestion #PowerBITips #PowerBIPro
👉 FREE Power BI Step-by-Step Tutorial web.learnpowerbi.com/tutorial
👉 Download Accompanying PBIX Files for Video at web.learnpowerbi.com/download/
✅ Subscribe to always get my latest videos: kzbin.info?su...
🔴 Ask Questions LIVE on TalkPowerBI www.TalkPowerBI.com
👪 Join our LearnPowerBI Family www.learnpowerbi.com/training
===Most Popular Playlists===
• Power BI Beginner Tutorial: • Power BI Tutorial From...
• Ultimate Calendar: goo.gl/pyki4K
• Power BI Data Modeling and more: goo.gl/WNtJFv
⚡Power On!⚡
-Avi Singh
www.LearnPowerBI.com
www.AviSing.com

[@sqfiitteam4679]

Avi, Thanks for your videos, they have been very helpful on my power bi journey. My question is why does the ultimate calendar table have 53 weeks of year instead of 52?

[@Rappasta]

hi, I am trying to calculate a YTD value by selecting in the slicer the week number. so if I select the week 10, then the returned values should be "value week 1 + value week 2... + value week 10". I can only do it by using TOTALYTD and selecting the week date instead of the week number. do you have another solution for it? thanks!

[@manojkahar5718]

Looking for same concept, thank you Avi making my life easy

[@learningwithnayiba]

Thank you Avi. This is very helpful. The Calculate function is not working for me. No drop downs

[@andrea31050]

Hi, your video have been very helpful for me. I'm looking to so something similar to what you did in this video, but with the option of selecting the week via slicer. As, if i select week 23, i would like the table to show the data for week 23 and 22. if i select week 10, the table should show data for weeks 10 and 9, and so on. However i have been struggling to achieve the result i need...

[@johnhatcher579]

Avi, how did you set up the underlying table and header for curr vs pre week's to show weekdays and the header.

[@AnnalalaMega]

Hi Avi, Thanks for your helpful video. My question is: I need to show data by reporting months which start from 24th of their last month to 23th of these months (e.g: The duration of December,2022 in my report will span from 24th November,2022 to 23th December, 2022) and by my reporting weeks which start from the last Thursday to its current Wednesday. How does my report always show current REPORTING WEEK/MONTH vs. prior REPORTING WEEK/ MONTH? And is there any way to calculate the portion of top 10 product code by sales automatically? (because my product code lists include many codes so create each measure to calculate each of their portion is not the best choice). Looking forward to hearing from you!

[@ericaleverson9430]

I used this for work today, thank you so much!

[@PowerBIPro]

Wonderful!

[@Harpreet06]

I got the calender table from you but how do I change the start of the week? I want my week to start on Monday and end on Sunday.

[@MistaChamo]

This is great. What about something where if you select a given date, it compares the totals for that day to the average of the prior X number of that same day of the week? For instance, if I select X date, and that is a Monday, it will compare the Monday I selected to the average Y Mondays prior to the one I selected.

[@stephg-xw2gj]

Great video, really useful, what would have been challenging, add % per day current and prior week

[@devyaniwalecha8019]

Hi Avi, Could you please help with how to create current week offset flags in a report?

[@joan322]

I think you are missing showing some steps within this video. Such as how to make the formulas dropdown. Because I cannot seem to get it to work with the workweek

[@saichandu5965]

How to take the sales change wow on only one particular day of the week once a week sales calculated and week over week change....any way to select particular date on dataset and show the change...please help

[@curtispetzak9245]

Does that work with summarized data? If I wanted to slice by vendor or market sales deltas?

[@killianokeeffe2440]

Hey - I have a unrelated question - I have been trying for a number of weeks to incorporate a chiclet sliver to my report. I wanted to create a slicer with headshots of my team members (just thought it would be cooler then a boring slicer) but for some reason I cannot get all 4 images to work. I have saved the image links to our company sharepoint and into our team so the links should be accessible and also categorized the links to "image url". But still no luck. Any help would be amazing!!!!! Thank you

[@SrivastavaKhushboo]

Must awaited as I have done earlier

[@garethmorrall1047]

Exactly what Im looking for bit power BI is beyond me. Can this be done in excel pivot table?….. a this week to last week side by side then a variance?

[@BobMbai]

Awesome stuff

[@MuhammadAliImran]

Dear Avi, Is CurWeekOffSet a calculated column? I think, it is a dynamic value based on current date, isn't it? How is the formula?

[@Harpreet06]

If you download his calender table, you'll see it in the queries when you click transform data how he made it. If you're lazy like me, here it is but doesn't make sense unless you see the other queries tbh: = Table.AddColumn(#"----WeekSequenceNum Complete----", "CurWeekOffset", each [WeekSequenceNum] - Current_WeekSequenceNum, Int64.Type)

[@MuhammadAliImran]

@@Harpreet06 ah thank you...

[@vibhors50]

Values aren't reflecting in sales current week and sales prior week measures in my .pbix file. Kindly help me understand why is this issue occuring

[@wendycasale2702]

I’m having trouble changing the week start day. What if I want the weeks to be Mon - Sun?

[@WalIbru]

Hi Abi, pls. how do you tackle ISOWEEKNUM? This exists in excel but PBi only has WEEKNUM function.

[@PowerBIPro]

In Power BI, you can calculate the ISO week number by using the following formula: ISOWeekNum = WEEKNUM([Date], 21)

[@WalIbru]

@@PowerBIPro Thank you for replying Avi. I’m getting this error “Expression.Error: The name ‘WEEKNUM’ wasn’t recognized. Make sure it’s spelled correctly”

[@WalIbru]

Works now thanks. Instead of typing the formula in the Data view, I was doing that in the Edit query.

[@FELIPPEVIANNA]

I have a situation. My "current week" is actually the last week of deliveries. So, my question is, how can I set up my current week to always be the last week of deliveries (fact table)? I would appreciate your help.

[@PowerBIPro]

Hey @FELIPPEVIANNA, That is a great scenario. And I think I can help you with that. Can you send me a message on LinkedIn www.linkedin.com/in/PowerBIPro We may need some back and forth to solve this for you. And I check LinkedIn a lot more than I check KZbin comments here. Power On! / Avi

[@yamina1824]

Hi I want to create a rolling week number x axis with the current week in the center , in the left the 26 weeks before and in the right the 26 weeks after. Can you help me ?

[@PowerBIPro]

Hey Yamina, Would love to help. Please check out www.learnpowerbi.com/article/how-to-ask-good-power-bi-questions-and-get-them-answered And email me your question at [e-mail] You can also join my Live Power BI Q&A Call. See www.LearnPowerBI.com/question Power On! / Avi

[@samnad4972]

I am not getting any value after calculating the current week sales its showing 00. How to solve this one.

[@tanmoysana4024]

How can always calculate my weeks from yesterday, not including todays data

[@Visual0gamer]

how can i change the first day of the week as Monday??

[@PowerBIPro]

To change the first day of the week to Monday in Power BI, you can follow these steps: Click on "File" in the top left corner of the Power BI Desktop window. Select "Options and settings" from the dropdown menu. Click on "Options". In the "Options" dialog box, select "Regional settings" from the left-hand menu. In the "Regional settings" section, look for the "Week starts on" option and select "Monday" from the dropdown menu. Click on "OK" to save the changes. Once you have made this change, all your date and time functions, including WEEKNUM and other functions that rely on the week starting on a specific day, will use Monday as the first day of the week.

[@Visual0gamer]

@@PowerBIPro TY SO MUCH

[@opejoseph6814]

Wait, am I the only one seeing that “sales in prior week” is not actually in the “sales in current week” column as it should be? None of the digits in both column are not the same.