Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hi everyone,
I am looking for a way to use DateADD (or previousmonth) to have the previous month of the date that I am selecting.
Example :
Solved! Go to Solution.
@Anonymous
Try
=EDATE([DATE],-1)
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Anonymous
Try
=EDATE([DATE],-1)
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Anonymous ,
Try like
VAR SelectedDateCurrent = SELECTEDVALUE('Date'[Date])
Return DATE(year(SelectedDateCurrent),Month(SelectedDateCurrent)-1,day(SelectedDateCurrent))
refer
another option
VAR SelectedDateCurrent = maxx('Date' , dateadd('Date'[Date],-1, month))
Return SelectedDateCurrent
dateadd need continuous dates
User | Count |
---|---|
13 | |
12 | |
8 | |
8 | |
6 |
User | Count |
---|---|
28 | |
19 | |
13 | |
11 | |
7 |