How To Obtain Previous Week Values In Power BI

[@wounce]

Decent video but would have liked to have seen how the WeekOffset column was created, seeing as it is needed to complete the DAX

[@wadhaali4037]

I think the teacher use offset function

[@edmondegaru7139]

@@wadhaali4037 how do you use the offset function

[@mohamedaymenjomaa7907]

@@edmondegaru7139 yes it miss how to calculate the offset fuction

[@darandavis]

Very helpful Brian! I like that you covered both scenarios.

[@EnterpriseDNA]

Hi Daran, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI video tutorials. Cheers!

[@sarajvo2010]

very useful. please think about mentioning "with DAX" in title or description given that in video there is great example :). thank you

[@johnzea3566]

thank you, this helped me solve a problem i had with a client's report!

[@EnterpriseDNA]

Hi John, glad you found this video helpful! If you haven't yet, you can subscribe to our channel to see all our upcoming tutorials and announcements. Cheers!

[@traceefry-annan911]

wish I could like the video a 1000x... very helpful and straight forward

[@mehdihammadi6145]

Great content Brian! Thanks for sharing

[@EnterpriseDNA]

Thanks for the continued support, Mehdi!

[@PedroCabraldaCamara]

Such a cool trick Brian. I've learn another way with Sam, a year ago I think. Thanks a lot for this

[@EnterpriseDNA]

Hi Pedro, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI video tutorials and announcements. Cheers!

[@ritafainshtein3851]

Great Video!! Brilliant as always, thank you for sharing May you show more examples of using 2 indexes and group by?

[@EnterpriseDNA]

Hi Rita, appreciate the suggestion. We will put this on our list. If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI video tutorials and announcements. Cheers!

[@Jeff-pe5qz]

Curious why in your original table, 2016 showed Max Week # of 53, but in your solution, 2016 only goes up to 2016-52. In your 3rd (Imke) technique, you didn't scroll down past 2015 so I was curious what it would've showed. Thanks for the tips here! Kindof amazing that Power BI doesn't handle week intelligence more inherently.

[@EnterpriseDNA]

Hello Jeff, Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post it. The reason why "Max Week #" shows 53 as a result for the Year 2015 and 2016 in original table is because these two years contain the overlapping dates. That is, Week No. 53 for both these years contain the dates from 28th Dec, 2015 to 3rd Jan, 2016 and therefore, both the years showcase 53 as results when "ISOWeekNumber" is used. Ideally, year 2015 contains 53 weeks and not year 2016. The reason being is, the year in which new week begins is considered as a starting point for week counting. So in this case, week 53rd began on 28th Dec, 2015, the year 2015 will showcase the results as 53 weeks and not the year 2016. And that's what our EDNA Expert - Brian Julius has explained in the video that, it's better to use "WeekOffset" since it's in a continuous format and doesn't reset when new year begins otherwise we would've faced the same over-lapping problem, the way we faced in the case of "ISOWeekNumber". Lastly, in the case of Power Query based solution as well, it would've showcased the same results since Week No. 53 falls in the year 2015 and not 2016. You can try the solution in your PBIX file as well and then scroll all the way down till end of year of 2016. For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well. Hoping you find this useful. Subscribe to our KZbin channel so that you don't miss out on any updates pertaining to the Power BI. You can also join our Power BI group on LinkedIn to receive latest updates on Power BI. Cheers, Enterprise DNA forum.enterprisedna.co/ kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/

[@armanazote6230]

I have problem if the previous week do not have data. the next week that have data will become the Previous week or the current week. this is the problem that I encounter. Hope we can prevent it.

[@EnterpriseDNA]

Hi arman, Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post it. Well, in that case, you can make use of "LASTNONBLANK()" or "LASTNONBLANKVALUE()" function to avoid that type of problem. For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well. Hoping you find this useful! You can subscribe to our KZbin channel so that you won't miss out on any Power BI updates. You can also join our LinkedIn group to receive latest updates on Power BI. Cheers, Enterprise DNA forum.enterprisedna.co/ kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/

[@wayneedmondson1065]

Interesting! Thanks for sharing the solution. Thumbs up!!

[@joffrimpong7720]

Thanks for your video, but I would like to ask is there a Text to Columns function as in excel, in Power Query or Power Bi?

[@EnterpriseDNA]

Hello Jof, Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post it. Well, the answer is - No. There's no option like that available in Power Query Editor like we've it in Excel. For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well. Hoping you find this useful. Also, make sure that you're subscribed to our KZbin channel so that you don't miss out on any updates pertaining to the Power BI. You can also join our Power BI group on LinkedIn to receive latest updates on Power BI. Below are the links provided for the reference purposes. Cheers, Enterprise DNA forum.enterprisedna.co/ kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/

[@tlowp]

So close to being great. You don't show how you used offset to calculate week offset.

[@EnterpriseDNA]

Hi T LowP, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!