Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
HI,
I need to get the value of 7 days ago. Example:
For 7/1/2019 i need the value of 6/24/2019
For 7/2/2019 i need the value of 6/25/2019
I try this column measure but give me a wrong value:
Solved! Go to Solution.
@VijayP thanks for your answer, but is not working.
May be my explination is not clear.
I need the value of 7 day ago to calculate.
For 7/1/2019 i need the value of 6/24/2019
CALCULATE(TotalSales,filter(all(dates),date[date]=date[date]<6) Try this
@SQUILES wrote:HI,
I need to get the value of 7 days ago. Example:
For 7/1/2019 i need the value of 6/24/2019
For 7/2/2019 i need the value of 6/25/2019
I try this column measure but give me a wrong value:
LookupValueofPrevDate = CALCULATE(MAX('T8 Wireless'[DATO_30]),FILTER('T8 Wireless',WEEKDAY('T8 Wireless'[DATA_PERIODO])=WEEKDAY(DATEADD('T8 Wireless'[DATA_PERIODO],-7,DAY))))Any help will be appreciate. Thanks Again.
Proud to be a Super User!
@VijayP thanks for your answer, but is not working.
May be my explination is not clear.
I need the value of 7 day ago to calculate.
For 7/1/2019 i need the value of 6/24/2019
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |