Forum Discussion
Solved
Need Help with Dax- Interview Question
Hi,
I just shared the interview question that asked to me during on the interview.
Consider we have only 2 dates.
Date:--------Previous Month
09/01/2022- Dec
09/02/2022- Jan
W...
what about:
Measure or Column = EDATE ( 'Table'[Date], -1 )
or
= MONTH( EDATE ( 'Table'[Date], -1 ))
Try this
PreviousMonth=FORMAT(EDATE('Date'[Date],-1),"mmm")