WeekNum and ISOWeekNum Function in Power Apps

preview_player
Показать описание
During this session we will talk about two interesting Power Fx formulas. We will talk about WeekNum and ISOWeekNum function in detail! The main difference between WeekNum and ISOWeekNum function is the way it calculates the first week of the year. The syntax is different for both functions! So, Let's talk about this in detail throughout this session.

During this session, we will learn the following concepts:
1. How to calculate Week Number in Power Apps?
2. WeekNum Power Fx Formula in Power Apps
3. ISOWeekNum in Power Apps

Chapters:
00:00 Start
00:40 Requirement
01:14 WeekNum Vs ISOWeekNumber
01:40 WeekNum in Power Fx
02:03 ISOWeekNumber in Power Fx
02:50 Syntax for WeekNum
03:26 WeekNum with Start of Week
03:48 ISOWeekNumber Syntax
04:16 Test ISOWeekNumber
06:12 End

#PowerApps #PowerFx #PowerPlatform #DigitalDhruvin #DhruvinShah #PowerAddicts #Microsoft

📷 Follow me on Instagram:

🌐 Looking for Consultancy? Connect Here!

🌐 Follow me on all social Media Handles:
Рекомендации по теме
Комментарии
Автор

Hi, how can you get the accurate First Date of each ISOWeekNum? I am having error when for example: selecting January 1, 2023 *Sunday, it should give me Dec 26, 2022 as First Date of the week but it gives Dec 25, 2022 instead.

mardithpascua
welcome to shbcf.ru