Week Numbers in Sequential (Chronological) Order when Two or More Years' Data in Power BI

#LearnPowerBI #PowerBIforBeginers #PowerBIDAX

- How to use WEEKNUM function in Power BI
- Explain DATEADD, WEEKDAY DAX functions
- Use Variables and Temporary Tables in Power BI
- Use SUMMARIZE DAX in Power BI
- Use SUMX DAX in Power BI
- Use FIRSTNONBLANK DAX in Power BI
- Use IF Conditions in Power BI

[screaminbrod]

awesome! and thanks a bunch for painstakingly walking us through this type of concern. God Speed!

[cparedes]

Many thanks for this tutorial. It was of great help an it works.
Now I do it in a simpler way. In my Date Table I do:

1. Add a column for sequential day number. If you need to adjust it by subtracting a fix number of days to have it start on the day You want, do so
2. Add a second column for the NewWeekNumber by applying: Trunc(sequentialDay/7)+1. Deal with an IF statement for NewWeekNumber < Zero
3. You are done!

I use NewWeekNum in my visual and it works great!

[josephthibault]

Great Lesson! Thank you so much! Needed this to create a sort column. They really need to add better weekly time intelligence to BI.

[pedroeliasperezsalazar]

It was an awesome lesson, I will adapt this according to my needs though.
Greetings from Colombia dude!! keep it up. Btw, I already subscribed to your channel.

[gilyoshi]

Excelent really helped! How can I define as week 1 a specific day of year?

[learntech]

Thankyou so much, that really helped me

[narendrababu]

You definitely deserve more subscribers.

[RobertMelgerd]

Great video. However, I want to present the “normal” week numers in the x-axis, not the seq-order. How do i do that?

[walaaahmed]

Thank you so much for this great video! Could you please write the code for the logical function IF that returns the chronological order for week number for January 2020, please? Thank you.

[GLozadaC]

Great videos, can you do the same but for months ?