Forum Discussion
Get next month based on status
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
Thank you, it worked
few doubts,
1) Max() return the largest value. How is this working in this expression.
2) when i tried using existing column in expression the fornula always shows error. but when i use it inside max column it worked.
please excuse my English as its not my first language.
Community Supporthi Anonymous
Measure is a summary value by its row context in a visual, so MAX/MIN has the same logic.
https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/
Regards,
Lin