How to Enable Weeks in Power BI

[@vv9730]

in this case,week number is year oriented ,i.e.week number will be same for 1 week of every year,how to make it progressive number with year..???

[@nikkhairol3019]

Thanks for your informative video, may I know how can I put weeks and year simultaneously on x axis since in the video only show one parameter at one time...thanks

[@andreibudaes3966]

Google's been disappointing me a lot lately with search results. Can anyone tell me what is that *.[Day]* notation at minute 2:37 called? I want to create a measure that groups a DISTINCTCOUNT([Col]) by *.[Month]* but can't for the love of God find any reference without having to create a separate column. I don't want to create a separate [Month] col but would like to reuse what Power BI already created.

[@jpg6832]

Hello, thank you, managed to make it work although I seem to get the week number displaced by one. We are currently in sept 2021 week 36 and it showing as week 37. Any ideas?

[@rimebeckoury5051]

Same for me

[@GeekDecodersPowerBILearning]

You can add a contact if needed. Ex Weeknum(date) + 1 (or minus one)

[@shimiaozhao]

This is nice video. I had to put together a report with weekly data, I was able to complete it after I watched your video. Thanks a lot.

[@GeekDecodersPowerBILearning]

Thank you.

[@walaaahmed7666]

Thank you so much for this great video, it very helpful. What should I do if my first week doesn't have a specific day to start with as it can start on either Monday or Tuesday? Thanks

[@yose12]

hi, what if my table crosses over the next year? For example I still want to have a chronological presentation but the weeknum will reset to 1 after 52. Thank you.

[@GeekDecodersPowerBILearning]

Yes, that will happen. If you want to have the next years 1st week as 53, then you need to write logic using DAX. IF Year = 2021, WeekNum = Weeknum + 52 in DAX. Is it the answer you expected?

[@GeekDecodersPowerBILearning]

Here is my new video for the complete answer: kzbin.info/www/bejne/qaXVpaOobqmeiJY

[@rhlgvl]

Week numbers comes as starting from January month. is there any way to change the week numbering starting from different month

[@OktosELAsywal]

Thanks Mate 👍👍

[@GeekDecodersPowerBILearning]

My pleasure

[@sandam390]

Very helpful thank you. You are explaining this in very simpleway

[@GeekDecodersPowerBILearning]

Thank you.

[@anujadassanayake6202]

Hi! Thanks for the video. By any chance are you from Sri Lanka?

[@imsteven3044]

Excellent Video, How can I put into the WeekNumber into the Data hierachy?

[@GeekDecodersPowerBILearning]

Please check my video : kzbin.info/www/bejne/qIeaf3uKaN6Km6c

[@aichakhadir3531]

Hello ; I congratulate you on the very important and instructive tutorials. I would like to calculate the cumulation per fortnight and per month and camparer it on the same date of the previous campaign (which begins in June and ends at the end of May). Could you tell me what should I do please? Thank you in advance

[@GeekDecodersPowerBILearning]

This is definitely doable. Can you send me a screen shot in facebook.com/groups/146546222070225

[@brianyang1572]

What if the time frame expand to more than one year, which is extremely common in real world, this method does work at all, as the week numbers will be repeat themselves.

[@heddyjazy6252]

very good job, my request is: I need to mention sales in this week vs last week, need that pbi detects this week and give me Values, thnx

[@deeptiahluwalia9839]

Thank you 😊

[@edwardm3464]

This great. And how to show data in 3 latest week? In visualization. Sample : w33 w34 w35 Only 3 weeks in a visualization

[@TheHnupak]

Really helpfull! Thank you

[@GeekDecodersPowerBILearning]

You're welcome!

[@Yashasvitech]

How to show last 4 week data

[@SimranSingh-sd9yo]

How to rename week number

[@melindagillen4058]

this was helpful! Than k you

[@GeekDecodersPowerBILearning]

Thank You.

[@EhsanRavana]

great

[@EmilPaje]

Thank you

[@pedrodcpaula]

Hello how are you? I would like to thank you for the tips you have shared on YT, I really liked your didactics. Could you help me solve an implementation, please? Considering the fiscal year 2022, basically the Quarter ends on the last Saturday of the current Quarter, examples: Q1 (from 01/01/22 to 04/02/22), Q2 (from 04/03/22 to 07/02/ 22), Q3 (from 07/03/22 to 10/01/22), Q4 (from 10/02/22 to 12/31/22). I imagine that the ideal would be to implement something related to the day of the week such as: last Saturday or the first following Monday of the current Quarter, so the logic will be applied in previous and following years. In addition, the same happens with Fiscal Weeks, where the last closing day is Saturday, here are some examples: SF01 (from 01/01/22 to 01/08/22), SF05 (from 01/30/22 to 05/02/22), SF48 (from 27/11/22 to 03/12/22) and SF52 (from 25/12/22 to 31/12/22). Fiscal year: Year 2022: 01/01/22 to 12/31/22. Fiscal quarter: Q1 (from 01/01/22 to 04/02/22), Q2 (from 04/03/22 to 07/02/22), Q3 (from 07/03/22 to 10/01/22), Q4 (from 10/02/22 to 12/31/22). Fiscal Weeks: FW01 (from 01/01/22 to 01/08/22), FW02 (from 01/09/22 to 01/15/22), FW03 (from 01/16/22 to 01/22/22), FW04 (from 01/23/22 to 01/28/22), FW05 (from 01/30/22 to 02/05/22), ... FW48 (from 11/27/22 to 12/03/22), FW49 (from 12/04/22 to 12/10/22), FW50 (from 12/11/22 to 12/17/22), FW51 (from 12/18/22 to 12/24/22), FW52 (from 12/25/22 to 12/31/22). I would greatly appreciate if you could consider help me. Thanks a lot, Peter Daniel.

[@VamsiKrishna-hf9rx]

Tq sir

[@GeekDecodersPowerBILearning]

My pleasure