Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Comparing Data with two different time lengjts

I would to compare the same data at two diffferent times on the same graph. Attahced is a photo showing what i am trying to do

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

      i was able to uplaod the photo

      • v-lili6-msft's avatar
        v-lili6-msft
        Community Support

        hi, Anonymous

             After my test, you may try to use DATEADD Function to add a calculate measure as below:

        Measure = CALCULATE(SUM(Table1[Sales]),DATEADD('Date'[Date],-30,DAY))

        Best Regards,

        Lin