Cumulative Flow Diagram of status within a workflow

[Haz_NZ]

Hi there,

Hoping you can provide some help here with some measures and a direction to get to the desired end result

The challenge

I am struggling to create a calculate function that sums a count of the max status (i.e. the latest status recorded on a particular day) so that it can be used to create a cumulative flow diagram.

Sample Data:

https://www.dropbox.com/s/gwnbgp21avsie40/SAMPLE%20DATA.pbix?dl=0

Expected end result:

I am trying to create cumulative flow chart using data from an event log as well as a date table (se...

Things to note: There may be multiple data records within one day or some days where a reference rec...

Sample data example:

REFCurrentStatusStatusDate/Time

SOP88805	Finished	Created	25/08/2022 8:08
SOP88805	Finished	Authorised	25/08/2022 10:08
SOP88805	Finished	Drafted	26/08/2022 8:10
SOP88805	Finished	Signed	26/08/2022 9:08
SOP88805	Finished	Reviewed	26/08/2022 15:08
SOP88805	Finished	Finished	26/08/2022 17:08
SOP88807	Reviewed	Created	26/08/2022 17:08
SOP88807	Reviewed	Authorised	27/08/2022 17:08
SOP88807	Reviewed	Drafted	28/08/2022 17:08
SOP88807	Reviewed	Signed	29/08/2022 17:08
SOP88807	Reviewed	Reviewed	30/08/2022 17:08
SOP99999	Finished	Created	27/08/2022 17:08
SOP99999	Finished	Authorised	28/08/2022 17:08
SOP99999	Finished	Drafted	29/08/2022 17:08
SOP99999	Finished	Signed	30/08/2022 17:08
SOP99999	Finished	Reviewed	31/08/2022 17:08
SOP99999	Finished	Finished	31/08/2022 17:08

[Anonymous]

Hi @Haz_NZ ,

You maybe able to use count() function to count the records then use sumx() function to get the cumulative value.

The description is partially hidden, please format it to text instead of url.

Best Regards,

Jay