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
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

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

        Hi Anonymous ,

         

        Still its giving me an error,