How to tell Power BI that my week starts Saturday and ends Thursday?

[AbdullahTammour]

Hello all!

I have an excel sheet that records sales by date: DD-MMMM-YYYY

I can easily extract week number from the date column using PBI.

but how to tell PBI that my week starts Saturday and ends Thursday (Only Friday as a weekend)?

Many thanks in advance.

[CheenuSing · Accepted solution]

Hi @AbdullahTammour

Try the following

WeekDay = WeekDAY(yourTable[yourDate],16)

This is a replication of WeekDay function in excel.  You can check out using excel to see the different options.

PowerBI Dax only shows 1,2,3.

If this solves your issue please accept this as a solution and give KUDOS.

Cheers

CheenuSing