Weekly sales for each month

[UditJ]

I have a date field with two years data. On filter there will be monthyear selected and in the table and i want to show Week 1 , Week 2 , Week 3 , week 4 and week 5 Sales (If there are) as separate columns in the table. 

Week 1 Sales    Week 2 Sales    Week 3 Sales   Week 4 Sales                         ->      based on monthyear selection 

Any suggestions ?

[riyasiak]

1. Under the Transform Data --> Create a Custom column in same table: WeekofMonth = Date.WeekOfMonth([Date]). Where [Date] is the same date field you have.

2. Create another Custom column Week number = "Week# " & WeekofMonth

3. Use Week number field also along with the monthyear selected.

After above steps, Check the visual and adjust per your needs

[Anonymous · Accepted solution]

Hi @UditJ ,

Try using the matrix visual. And create a week number column using DAX. Below is a sample for reference.

Weeknum = WEEKNUM([Date],2)

You can download the attachment for more details.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.