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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
VeronicaC
Frequent Visitor

How to show prior entry when month missing

I am trying to create a columnd to show me prior month status but because my months have gaps in them I am getting blanks

 

I have the following data. The first 3 are in my dataset and I am trying to create the 4th

 

Report MonthCustomerStatusPrior Month Status
JanABCRed 
FebABCRedRed
MarchABCYellowRed
AprABCYellowYellow
MayABCGreenYellow
JanDEFRed 
FebDEFYellowRed
MayDEFGreenYellow
JanGHIRed 
MarchGHIYellowRed
MayGHIGreenYellow
1 ACCEPTED SOLUTION

@VeronicaC 

Please try

Prior Month Status =
MAXX (
TOPN (
1,
FILTER (
CALCULATETABLE ( 'Table', ALLEXCEPT ( 'Table', 'Table'[Customer] ) ),
'Table'[Month] < EARLIER ( 'Table'[Month] )
),
'Table'[Month]
),
'Table'[Status]
)

View solution in original post

4 REPLIES 4
tamerj1
Super User
Super User

Hi @VeronicaC 

month is text or date data type?

it's date type

@VeronicaC 

Please try

Prior Month Status =
MAXX (
TOPN (
1,
FILTER (
CALCULATETABLE ( 'Table', ALLEXCEPT ( 'Table', 'Table'[Customer] ) ),
'Table'[Month] < EARLIER ( 'Table'[Month] )
),
'Table'[Month]
),
'Table'[Status]
)

omg this worked THANK YOU

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

October NL Carousel

Fabric Community Update - October 2024

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

Top Solution Authors
Top Kudoed Authors