Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |