Forum Discussion

cham's avatar
cham
Icon for Post Patron rankPost Patron
7 years ago

Difference between previous week

Hi,     Here is my data set, Date  Spend Pay 22-07-19 589.32 425.22 24-07-19 3652.85 1833.72 21-07-19 3659.5 2744.64 24-07-19 2312.59 1726.67 24-07-19 519.59 347.25 ...
General Comment
Interesting Links
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hey cham 

You can use a calculated column:

% = CALCULATE(((SUM(T20[Spend]) - SUM(T20[Pay])) / SUM(T20[Spend])),
FILTER(T20, T20[WEEKNUM] = EARLIER(T20[WEEKNUM])))

Where WEEKNUM is another column:

WEEKNUM = WEEKNUM(T20[Date ])

I did NOT QA this solution.

 

Thanks!
A

cham's avatar
cham
Icon for Post Patron rankPost Patron
7 years ago

Hi Anonymous ,

 

What is this T20 you mentioned in your measure? Can you please explain it to me?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    cham 

    Thats the table name.

    In your case it is Sheet1

    Thansk!
    A

    • cham's avatar
      cham
      Icon for Post Patron rankPost Patron
      7 years ago

      Hi Anonymous ,

       

      This is not working see below pic,

       

      Could you please help me to sort this?

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        cham 

        You'll have to create a column, not a measure.

        Cannot use EARLIER in a measure.

        But, you can find ways to workaround this.

         

        Thanks!
        A