Forum Discussion
Automating measures to update each week
The solution is excel based in the original file. The column headers now update each week to the correct reference, for example WC 10/05 is currently called "5" but next week WC 17/05 will be called "5". This means the measure is "Week 5 = SUM([5]) so I no longer need to update the measures manually.
Community ChampionAnonymous Sorry, what was the solution you have used?
Anonymous wrote:This is similar to the approach I've now taken with a formula in excel that changes each week based on today's date.
Thanks for your help everyone, I think the fact that the columns are all headed with dates has confused the siutation. I'm familar with unpivotting/pivotting columns and this would not have solved the situation as there are 52 columns to unpivot.
Kind regards,
Danielle
I'm curious to hear what you've done, because I'm still confused why you can't just unpivot and then use DAX to calculate ThisWeek and PreviousWeek and %Diff that will be much more efficient than working with 52 columns.
Unpivoting 52 columns is possible...
Look forward to hear what you've done.
The solution is excel based in the original file. The column headers now update each week to the correct reference, for example WC 10/05 is currently called "5" but next week WC 17/05 will be called "5". This means the measure is "Week 5 = SUM([5]) so I no longer need to update the measures manually.
v-kelly-msftCommunity Support
Hi Anonymous ，
Is your issue solved?If so,can you mark the reply as answered to close it?
Much appreciated.
Best Regards,
KellyDid I answer your question? Mark my post as a solution!