Forum Discussion
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
We have to create a measure or column to show the Previous month of the each date:
I tried PreviousMonth(Table[Date], its returning only jan in February Month. But in January its not returning the Dec Month.
I dont know its is possible or not. Please advice.
result that i got.
what about:
Measure or Column = EDATE ( 'Table'[Date], -1 )
or
= MONTH( EDATE ( 'Table'[Date], -1 ))
6 Replies
what about:
Measure or Column = EDATE ( 'Table'[Date], -1 )
or
= MONTH( EDATE ( 'Table'[Date], -1 ))
you are welcome. Good luck with the interview.
lease try the following
base data
Mesure and result
formula:
Measure Previous Month = var var_ReferenceDate = MONTH(MAX(Dates[Date])) Return IF(var_ReferenceDate=1,12,var_ReferenceDate-1)There might be a better solution but this is the quick and dirty one 🙂
Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.Found another one 🙂
Measure Previous Month = MONTH(EOMONTH(MAX(Dates[Date]),-1))Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.Try this
PreviousMonth=FORMAT(EDATE('Date'[Date],-1),"mmm")
