Need Help with Dax- Interview Question

[NavaneethaRaju]

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.

[Mikelytics]

@NavaneethaRaju 

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.

[Mikelytics]

Hi @NavaneethaRaju 

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.

[FreemanZ · Accepted solution]

hi @NavaneethaRaju 

what about:

Measure or Column = EDATE ( 'Table'[Date], -1 )

or

= MONTH( EDATE ( 'Table'[Date], -1 ))

[NavaneethaRaju]

Hi @FreemanZ , 

Its working,  Thanks for your earliest reply.

[FreemanZ]

you are welcome. Good luck with the interview.