How to show historical status value?

Questions & Answers
3

Hi @Marita_Norvele
I’ve managed to do a step further with my formula. So, for now I have what I need with this formula:

CASE WHEN
not IsEmpty([Issue].CurrentHierarchyMember.Get('Status updated at'))
THEN
Order(
Filter(
  [Transition Status].[Transition Status].Members,
  ([Time].[Week].CurrentDateMember,    
  [Measures].[Issues history])>0  
),
[Measures].[Transition from status last date],
BDESC
).item(0).getCaption
END

This give me a nice table:

image
image2188×390 34.1 KB

However, my final goal is to show issues logged by user from team. So when I add “Logged by Team” and “Logged by” dimensions to rows I got this table with #null values of statuses:
status on date 2
status on date 22421×457 43.8 KB

I think that is because I didn’t specify those demensions in formula. Unfortunately, I have no idea how to fix it. So any help is highly appreciated.

Thanks in advance,
Ksenya.