Power Query how to create and use an ISO Week Number function in Power BI
Steps to create and use a function in Power Query:
1. Define 1 or more parameters.
2. Create query.
3. Create function from query.
4. Invoke function.
Rules for ISO week number:
1. First day of the week is Monday.
2. Each week from Monday to Sunday has the same week number.
3. Week 1 of the year is the week with the first Thursday of the year,
meaning more than half of the days of the week are in week 1.
If January 1st is on Monday-Wednesday 0-2, it will be week 52 or 53 of the preceding year.
If January 1st is on Thursday-Sunday 3-6, it will be week 1 of the current year.
Steps to determine ISO week number:
1. Determine the date of Thursday of the current week.
2. Determine January 1st of the date from step 1.
3. Calculate the number of days from January 1st to the date from step 1.
4. Divide the number of days from step 3 by 7, round down and add 1.
Видео Power Query how to create and use an ISO Week Number function in Power BI канала MarcelBeug
1. Define 1 or more parameters.
2. Create query.
3. Create function from query.
4. Invoke function.
Rules for ISO week number:
1. First day of the week is Monday.
2. Each week from Monday to Sunday has the same week number.
3. Week 1 of the year is the week with the first Thursday of the year,
meaning more than half of the days of the week are in week 1.
If January 1st is on Monday-Wednesday 0-2, it will be week 52 or 53 of the preceding year.
If January 1st is on Thursday-Sunday 3-6, it will be week 1 of the current year.
Steps to determine ISO week number:
1. Determine the date of Thursday of the current week.
2. Determine January 1st of the date from step 1.
3. Calculate the number of days from January 1st to the date from step 1.
4. Divide the number of days from step 3 by 7, round down and add 1.
Видео Power Query how to create and use an ISO Week Number function in Power BI канала MarcelBeug
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Video 6 - Power Query solver for 12x12 binary puzzles - List.Zip to transpose a listPower BI / Power Query - Split column at delimiter "FixedWidth"Power Query - Strange things with Excel durations (times)Bemint uw Excel afrondingsfuncties - maar niet AFRONDEN.N.VEELVOUDVideo 8 - Power Query solver for 12x12 binary puzzles - Trial and errorVideo 4 - Power Query solver for 12x12 binary puzzles - Parameter recordPower Query - Global Fixed Time Zones from WikipediaExcel/Power Query toepassing - Bemint uw Grootboek - RGS koppeling - een impressiePower Query - Bemint Global DateTime Table 2015-2024Power Query and global datetimes - Olympic Winter Games 2018 in PyeongChangPower Query versus Excel: Number.Mod versus MODPower BI - Datetime field in Report View not the same value as in Data ViewBemint Power Query M Functions dashboardVideo 5 - Power Query solver for 12x12 binary puzzles - List.AccumulatePower Query - Trim, whitespace and number conversionsPower Query - Keep rows with highest Revision # (no sound)Power Query - Creating a table with clock switches in the local Windows time zonePower Query - Convert Amsterdam datetimes (with DST) to Darwin datetime (fixed UTC offset)Power Query - Reaction on Excel Magic Trick 1414 - Better way to invoke standard functionVideo 7 - Power Query solver for 12x12 binary puzzles - Prevent duplicate rows and columnsVideo 1 - Power Query solver for 12x12 binary puzzles