Previous Day Value

[ajayemmadi1]

I am facing and issue in fetching previous day amount using current day amount. Can anyone let me know the exact DAX formula for the same.

[Anonymous]

Hi I just want to display last day sale of month. 

If last day sale is Zero then it should take previous day sale.

If that also zero then again it should take previous day sale.

Like that it should be dynamic.

Can you pleae write a DAX and send to me.

[v-yuezhe-msft · Accepted solution]

@ajayemmadi1 ,

Do you have a calendar table? You can use the DAX below. If you still have questions, please share sample data of your table and post expected result here.

Previous day amount= CALCULATE(SUM(Yourtable[Amount]), PREVIOUSDAY('DateTime'[DateKey])) 

Reference:
https://docs.microsoft.com/en-us/dax/previousday-function-dax

Regards,
Lydia

[Age]

What if the date of previous day didn't exist, for the example: 

Date                    Value
23 Jan 2021          10
24 Jan 2021          100
26 Jan 2021          200

can that DAX formula still works?

[Dhacd]

In this case, the earlier() function is your friend.

Regards.

Atma.