Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
AbdullahTammour
Frequent Visitor

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

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.

1 ACCEPTED SOLUTION
CheenuSing
Community Champion
Community Champion

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

 

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!

View solution in original post

1 REPLY 1
CheenuSing
Community Champion
Community Champion

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

 

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.