Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
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.
@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
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?
In this case, the earlier() function is your friend.
Regards.
Atma.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |