cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills 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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors