Forum Discussion
Get next month based on status
Hi All, I would like to get next month from a column "Modified" (which is of date data type). if the status column is "Completed". something like this. MeasureNextmonth = if (status == 'Comp...
HI Anonymous
This formula will work for a new column, if you want to create a measure, you need to adjust it as below:
Measure Nextmonth = IF (MAX(Tablename[status]) = "Modified", EOMONTH(MAX(Tablename[Modified]),0)+1 , EOMONTH(MAX(Tablename[Modified]),-1)+1)https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/
https://radacad.com/measure-vs-calculated-column-the-mysterious-question-not
Regards,
Lin
nvprasad
Solution Sage
Solution SageHi,
Try below measrue
Measure Nextmonth = IF (Status = "Modified", EOMONTH(H10,0)+1 , EOMONTH(H10,-1)+1)
This gives next month first date by defualt and you can use format function to get desired format.
Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂
Regards,
N V Durga Prasad