Forum Discussion
Sum Values on Same Date and 4 week average forecasting
I really could use some help. I've been struggling through this issue over the last couple of days and am truly at my wits end. Like most I am new to PBI and while having had some great success as ne...
vanessafvg
Community Champion
Community Championhi not sure this is in the right forum, deskop might be better. I can see what you trying to do, however can you explain what you struggling with exactly, where do you get stuck?
@vanessaafvg. I get stuck at adding the values forward then adding them together. I can independently create the 4 week average but it adds it during the current dates. I have tried parellelperiod... but it starts the calendar over during the same month, dateadd....again wont give me a full 18 months... nothing I am doing is working... I've tried creating variables with Calculate(Sum X and filters with Return to sum the two variables. No cigar.. Do I need to repost to the correct forum?