Forum Discussion
Automating measures to update each week
Hi everyone, I hope someone can help with a requirement I have with some measures in a report? I am fairly new to using Power BI so apologies if the language I use is not quite correct. I ha...
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.
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.
Hi Anonymous ，
Is your issue solved?If so,can you mark the reply as answered to close it?
Much appreciated.
Best Regards,
Kelly
Kelly
Did I answer your question? Mark my post as a solution!