cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
ashley_khor Frequent Visitor
Frequent Visitor

How to group by dates in PowerBI?

Hi all,

 

I am wondering how to use PowerBI to group the dates? I am looking to show a weekly dashboard. 

 

This is the original data

 

Grouping by Dates.JPG

 

Based on that, I want to PowerBI to automatically create a column next to my data that looks like this:

 

Grouping by Dates end result.JPG

 

This shows that between specific dates, I can catogorise them as 'week 1', 'week 2' etc. I want to be able to do that quickly and find a way to automate the process instead of going through the data and manually labelling them with respective weeks. 

 

Thanks!

 

Ashley

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: How to group by dates in PowerBI?

@ashley_khor week 1 and week 2 etc.. are these year week number, if yes, you can use weeknum function to create this column






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

1 REPLY 1
Super User
Super User

Re: How to group by dates in PowerBI?

@ashley_khor week 1 and week 2 etc.. are these year week number, if yes, you can use weeknum function to create this column






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 135 members 1,811 guests
Please welcome our newest community members: