Financial Week Totals

[Anonymous]

Hi

Ive asked this before but i since realised i need a slightly different answer. Iam trying to get the totals for each week. I have in my table week number and fiscal number, Year & Week Number also day number. When I try and do something with the data the year & week number can not be sorted and there are 7 of the same week numbers as there are 7 days before it changes to the next number.

Is there a way that this can be added up so I can do week on week comparisons. As will probably be aware reading this I am relatively new so if you could talk through the best way and include any measurements I may need to do to achieve this The weeks i will need it for are from 2017, 2018 andn 2019.  Will it be best to let the weeks runconsecutivly or will it be ok for tehm to reset year after tear starting from 1 again? thanks

[v-xuding-msft]

Hi @Anonymous ,

I don't get you. You want to count the Fiscal Weeknum or calculate sum of values based on Fiscal Weeknum? Or the column of Fiscal Weeknum that you creaetd is not correct. You want to create a new one?

I created a sample that calculates sum of values based on Fiscal Weeknum. If it is what you want, you could have a try. If not, please share your expected results. Then we will understand clearly.

Measure = CALCULATE(SUM('Table'[Sales]),ALLEXCEPT('Date','Date'[Fiscal Weeknum]))

 

Best Regards,

Xue Ding

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

[Anonymous]

Hi

Thank you for the insight and it nearly works. I require this calculation for each week and year, i noticed that your week numbers have increments of 4 weeks. I am trying to get the totals for each fiscal week from 2017 - 2019 to i can compare week on week the sales.

Your solution nearly works but i think its adding up each fiscal year week number if that makes sense. As it spread over 3 years there will be 3 x fiscal week 12,13,14 etc.

I need the year column, Fiscal week to be consecutive and a total next to it so comparisons can be made. I hope this makes more sense.

I need the year column,  Fiscal week to be conscutive and a total next to it so comparisions can be made.  I hope this makes more scence. @v-xuding-msft thank you