Power BI: Calculating Week number from Date Column, starting from Saturday and Ending on Friday

Question

1 Answer

0 votes

1 answer

asked Jan 13, 2021 in BI by Chris (11.1k points)

0 votes

1 answer

asked Jan 13, 2021 in BI by Chris (11.1k points)

0 votes

1 answer

asked Nov 30, 2020 in BI by Chris (11.1k points)

0 votes

1 answer

asked Mar 3, 2021 in BI by Chris (11.1k points)

0 votes

1 answer

asked Jan 5, 2021 in BI by Chris (11.1k points)

Vamsee Krishna · Answer 1 · 2020-12-21T06:57:15+0000

Check with this formula

WeekNum = WEEKNUM(DateTable[Date] + 1) +
              IF(WEEKDAY(DATE(YEAR(DateTable[Date]), 1, 1)) = 7, -1, 0)

If u want to know more about the course then check the Power BI Training course