topic Value from last week in DAX Commands and Tips

Value from last week

Anonymous — Thu, 28 Oct 2021 15:26:05 GMT

Hello all,

I'm trying to collect whatever the value is from last week within a custom column. Below is an example of what it would look like

I've started the DAX code but currently this only turns blank fields:
VAR most_recent_date = LASTDATE('data'[date]) -7

VAR Calc = CALCULATE(

SELECTEDVALUE('data'[rollingRate]),

FILTER(ALL('data'), FORMAT('data'[date], "dd/mm/yy") = FORMAT(most_recent_date, "dd/mm/yy") ))

RETURN

Calc

Thanks in advance for any help!!

lbendlin — Sat, 30 Oct 2021 00:35:13 GMT

Remember that you have to calculate this from the point of view of the visual element if you do this as a measure.

So instead of

VAR most_recent_date = LASTDATE('data'[date]) -7

you would say

VAR most_recent_date =DATEADD('data'[date]), -7,DAY)

Note that "the value from last week" is not the same as "the value from the day seven days before the current day"

Anonymous — Tue, 02 Nov 2021 05:39:00 GMT

Hello Anonymous

Please see if the following query.

Prev Week Sales =

LOOKUPVALUE('Table'[Sale Value],'Table'[Date],DATEADD('Table'[Date],7,DAY))

Hope this helps.

Kindly accept it as a solution if it satisfies your requirement.