Forum Discussion
Filter Yearly Data by Week
I have sales volume data for years 2019 - 2021. I only have 18 weeks of data in 2022. We want the line graph to cut off weeks 19 - 52 in years 2019, 2020 and 2021.
Hi Anonymous
Does your table has Date column or does it only have weekly sales amount?
If your raw data is similar to below table,
You can try this measure to calculate the sales amount. Then put it on Y axis of the line chart.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
2 Replies
Hi Anonymous
Does your table has Date column or does it only have weekly sales amount?
If your raw data is similar to below table,
You can try this measure to calculate the sales amount. Then put it on Y axis of the line chart.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.