Reply
Guillaume_S
Frequent Visitor

Value for previous month without blank

Hi,

I wrote a measure where I want to retrieve the value of the previous month without taking the group into account. However, everything I test takes the group into account. Does someone have an idea ?

My values :

DateGroupValue
202401A10
202402A10
202403A10
202404B15
202405B15
202406B15
202407B20
202408B20

 

My measure :

Previous Mth = CALCULATE([Value],PREVIOUSMONTH(Calendar[Date]))


My results :

DateGroupValuePrevious Month
202401A10 
202402A1010
202403A1010
202404A 10
202404B15 
202405B1515
202406B1515
202407B2015
202408B2020


What i looking for ..

DateGroupValuePrevious Month
202401A10 
202402A1010
202403A1010
202404B1510
202405B1515
202406B1515
202407B2015
202408B2020


Thanks for your help !

Guillaume

 

1 ACCEPTED SOLUTION
ray_aramburo
Super User
Super User

If you will use this in only one visual you can leverage from visual calculations and use the PREVIOUS() function from it. 

ray_aramburo_0-1720798008372.png

 





Did I answer your question? Give your kudos and mark my post as a solution!

Proud to be a Super User!





View solution in original post

2 REPLIES 2
Guillaume_S
Frequent Visitor

@ray_aramburo Amazing ! thanks

ray_aramburo
Super User
Super User

If you will use this in only one visual you can leverage from visual calculations and use the PREVIOUS() function from it. 

ray_aramburo_0-1720798008372.png

 





Did I answer your question? Give your kudos and mark my post as a solution!

Proud to be a Super User!





avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)