Forum Discussion
Anonymous
7 years agoNot applicable
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
- v-lili6-msftCommunity Support
hi, Anonymous
It seems that your file is missing, Please upload again.
and maybe you need to use time Intelligence Functions to create the measure.
Best Regards,
Lin
- AnonymousNot applicable
i was able to uplaod the photo
- v-lili6-msftCommunity 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