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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
mesbah
Frequent Visitor

slice data as a week data from the date table in power BI

Hello, 

 

I have date column. I am looking to slice my data as week data. For an example- Monday ( 7/31/2023-8/7/2023). Can you please give me instructions?

 

1 REPLY 1
kpost
Super User
Super User

Your request doesn't seem to make sense, as each Monday would belong to two different "weeks".

 

For example when the date is 8/7, it would appear to belong to the week of 7/31 - 8/7 as well as 8/7 - 8/14

Can you please clarify the date ranges you want to be associated with each week?

Also, what exactly do you want to be in the column?  A date that is associated with the day the week ended?  A date that is associated with the day the week started?  A text field that shows the starting and end date of the week in the format  ( m/dd/yyyy-m/d/yyyy)?

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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