Seeing sales data by "WEEK' in power bi

Question

How can I display sales data by weeks,Calendar table and date hierarchy is listed as Year,Quater,Month and Day with no week,How can I display them??

Answer 1

 To get week in your calendar. use the following DAX equation which show the week number 

Week No = WEEKNUM(Table1[Date], 2)

To get start of the week use

Start of Week = 'Calendar'[Date]  - WEEKDAY('Calendar'[Date],2) +1

Want to earn a certificate in Power BI? here is the Power BI Course that will make you industry ready.

Also, check out our YouTube video to know the data visualization basics and best practices with Power BI