Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
How can I create a column that only gets the value from WeekNum on every start of the day in a Week?
Just like in the picture below with the desired output column.
Solved! Go to Solution.
Use following formula
Result =
IF(
Weekday([Date])=2,
[WeekNum],BLANK()
)
Use following formula
Result =
IF(
Weekday([Date])=2,
[WeekNum],BLANK()
)
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.