Forum Discussion
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 ...
Anonymous
Please try
Prior Month Status =
MAXX (
TOPN (
1,
FILTER (
CALCULATETABLE ( 'Table', ALLEXCEPT ( 'Table', 'Table'[Customer] ) ),
'Table'[Month] < EARLIER ( 'Table'[Month] )
),
'Table'[Month]
),
'Table'[Status]
)
tamerj1
Community Champion
Community ChampionAnonymous
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