topic How to show prior entry when month missing in DAX Commands and Tips

How to show prior entry when month missing

Anonymous — Fri, 30 Jun 2023 17:55:03 GMT

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 Month	Customer	Status	Prior Month Status
Jan	ABC	Red
Feb	ABC	Red	Red
March	ABC	Yellow	Red
Apr	ABC	Yellow	Yellow
May	ABC	Green	Yellow
Jan	DEF	Red
Feb	DEF	Yellow	Red
May	DEF	Green	Yellow
Jan	GHI	Red
March	GHI	Yellow	Red
May	GHI	Green	Yellow

Re: How to show prior entry when month missing

tamerj1 — Fri, 30 Jun 2023 18:59:43 GMT

Hi Anonymous

month is text or date data type?

Re: How to show prior entry when month missing

Anonymous — Fri, 30 Jun 2023 19:12:02 GMT

it's date type

Re: How to show prior entry when month missing

tamerj1 — Fri, 30 Jun 2023 20:02:25 GMT

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]
)

Re: How to show prior entry when month missing

Anonymous — Fri, 30 Jun 2023 21:06:05 GMT

omg this worked THANK YOU