Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
NavaneethaRaju
Helper IV
Helper IV

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.

NavaneethaRaju_0-1673255766419.png

 

1 ACCEPTED SOLUTION
FreemanZ
Super User
Super User

hi @NavaneethaRaju 

what about:

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

or

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

View solution in original post

5 REPLIES 5
Mikelytics
Resident Rockstar
Resident Rockstar

@NavaneethaRaju 

 

Found another one 🙂

Mikelytics_2-1673256293709.png

 

 

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.

------------------------------------------------------------------
Visit my blog datenhungrig which I recently started with content about business intelligence and Power BI in German and English or follow me on LinkedIn!
Mikelytics
Resident Rockstar
Resident Rockstar

Hi @NavaneethaRaju 

 

lease try the following

 

base data

Mikelytics_0-1673255981188.png

Mesure and result

Mikelytics_1-1673256157599.png

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.

 

 

 

------------------------------------------------------------------
Visit my blog datenhungrig which I recently started with content about business intelligence and Power BI in German and English or follow me on LinkedIn!
FreemanZ
Super User
Super User

hi @NavaneethaRaju 

what about:

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

or

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

Hi @FreemanZ , 

 

Its working,  Thanks for your earliest reply.

you are welcome. Good luck with the interview.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.