Forum Discussion
Solved
get value from the previous month
hello, hope you all are well! I have a problem in a DAX measure.
I need to capture the previous result.
normally I would use DATEADD or PREVIOUSMONTH for this, but my problem is:
in my example, I do...
tks
Hello I tried this DAX and its very useful but may I ask how about if there's an order that needs to fill in like the image below. I need ($1535) to be in Mar 2022 since its the next month not in Apr 2022.
2nd column is the current month and 3rd column is the previous month
2nd column is the current month and 3rd column is the previous month.
Thanks in advance.