Forum Discussion

matrin's avatar
matrin
New Member
6 years ago

Create Weeks and calculate evolution

Hello everyone 🙂   Hope you're doing great!   I've got an issue: I've got a table with the number of sales during years (2017, 2018, 2019, 2020) aggregated by day.   However, I want to create ...
Need Help
v-yingjl's avatar
v-yingjl
Community Support
6 years ago

Hi matrin ,

You can create these calculated columns to calculate each year week total sales:

Week = WEEKNUM('Table'[Date],1)
Total =
CALCULATE (
    SUM ( 'Table'[Sales] ),
    ALLEXCEPT ( 'Table', 'Table'[Week], 'Table'[Date].[Year] )
)

If you want to see the evolution, use a line chart and multi select the slicer with year and month:

 

Here is my sample file that hopes to help you, please check and try it: Create Weeks and calculate evolution.pbix 

 

Best Regards,
Yingjie Li

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

matrin's avatar
matrin
New Member
6 years ago

Thanks a lot for your help!

 

Can't I just calculate the evolution thanks to a new metric? I need to add the evolution in my table, that is why