Forum Discussion
UditJ
Helper III
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 c...
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.
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.