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! Learn more
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.
| User | Count |
|---|---|
| 83 | |
| 48 | |
| 36 | |
| 31 | |
| 29 |