Shift a Measure one Date Down

Question

Hello Everyone,&nbsp;I have atable like this :&nbsp;I woulk like to shift the measure down by one date so that 17 alighns with the 20th and 42 alighns with the 19th etc.&nbsp;This is how I am calculating the measure :&nbsp;Today Orders Test = CALCULATE(&nbsp; &nbsp; COUNT(Orders[Reference]),&nbsp; &nbsp; FILTER(Orders,TRUNC(Orders[Required Date])=TRUNC(Orders[Date]+1) &amp;&amp; Orders[Status] &lt;&gt; "Departed"))&nbsp;Also note that Date refers to the analysis date i.e I run a report on the 25th to analyse performance for the 24th Therefore the date will be 24th. But Today's orders will be whatever orders are required on the day the report was ran hence required date = Date + 1

freginier · Accepted Answer

Hey there!&nbsp;To shift the measure down by one date, so that values from a particular date align with the next date in the table, you need to modify your DAX calculation to reference the previous day's value.&nbsp;Try this:&nbsp;Shifted Today Orders Test =VAR CurrentDate = SELECTEDVALUE(Orders[Date])RETURNCALCULATE([Today Orders Test],Orders[Date] = CurrentDate - 1)&nbsp;Hope this helps!😁😁

Forum Discussion

Shift a Measure one Date Down

2 Replies

Related content

Time Shifted Measures

Shifted Calendar Date and Time

Assigning Rotating Shift Teams based on Date

Derive 24 hour shift date. Overlapping calendar date

Unable to create Date Dimension and Date related measures