Forum Discussion
Creating a Status bar|| Help!
Hello- This seems like it should be very simple with a helper table and a couple measures but I am not having any luck. Goal: Create a status bar and show the previous statuses were met. Here is...
Hi jen8080 ,
How do you get the previous statuses? According to your sample data, the max of status of Company2 Fiji should be Transferred so the previous status should be Approved. But in the expected visual you have provided it's previous status is Formatted? Did I missed some points?
Sort order = LOOKUPVALUE('Status order'[Sort order],'Status order'[Status],Data[Status])
max_status = CALCULATE(MAX(Data[Sort order]),FILTER(ALLEXCEPT(Data,Data[Company],Data[Country]),Data[Status Date]=CALCULATE(MAX(Data[Status Date]),ALLEXCEPT(Data,Data[Company],Data[Country]))))
Best Regards,
Jay