Last Date -1

[luisClive]

Hi Everyone

i have a formula which works well for me

Daily revenue =

CALCULATE(SUM('Daily Net Revenue TRIAL'[Actual]),LASTDATE('Daily Net Revenue TRIAL'[Date]))

All i want is to calculate  now is Last Date -1 ............( that would be prior day)

Can you help?

I tried max -1 , did not work

[amitchandak]

@luisClive , Try like

CALCULATE(SUM('Daily Net Revenue TRIAL'[Actual]),LASTDATE('Daily Net Revenue TRIAL'[Date])-1)

[luisClive]

i tried this earlier, did not work

[v-deddai1-msft · Accepted solution]

Hi @luisClive ,

Would you please try to use the following measure:

Daily revenue =
CALCULATE(SUM('Daily Net Revenue TRIAL'[Actual]),FILTER('Daily Net Revenue TRIAL','Daily Net Revenue TRIAL'[Date] = MAX('Daily Net Revenue TRIAL'[Date])-1)

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[luisClive]

 Many Many thanks

I was also able to achieve the same using

Daily Revenue = CALCULATE(SUM('Daily Net Revenue TRIAL'[Actual]),DATEADD(LASTDATE('Daily Net Revenue TRIAL'[Date]),-1,DAY))