Forum Discussion
Helper IIIWeekly sales for each month
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 ?
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.
2 Replies
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.
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
