Forum Discussion

Helper I

7 years ago

Solved

Previous Day Value

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
7 years ago
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

4 Replies

Anonymous
Not applicable
4 years ago
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.
Anonymous
Not applicable
7 years ago
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
  Frequent Visitor
  4 years ago
  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
    Resolver III
    4 years ago
    In this case, the earlier() function is your friend.
    Regards.
    Atma.

Related content