Forum Discussion

andreazambon's avatar
andreazambon
Icon for Helper V rankHelper V
3 years ago

Delta value between 2 weeks

Hi there.  I'm trying to calculate the delta% between th last week agree with my filter anche le last-1 week.   I try with this:     Delta%PerditaLast = VAR PercMaxWeek= if(MAX(DateTable[week...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

Please show a couple of rows of your "DateTable" table.

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      3 years ago

      var thisweek = max(DateTable[Week])
      var prevweek = calculate(max(DateTable[Week]),all(DateTable),DateTable[Week])<thisweek)

      • andreazambon's avatar
        andreazambon
        Icon for Helper V rankHelper V
        3 years ago

        Thanks for your reply, I think that I can use this to my case. 

        Instead of this solution, what if I want to show the difference between a week and the previous one?

         

        For example, in WK15 I want to show the difference between WK 15 and WK14, in WK 14 the difference between WK 14 and WK 13..