Report ticket line chart

[Anonymous]

Hello, 

I have an issue with à ticketing flow. 

I want to create Three Measure with this result (see Excel attached) 

Can you help me ? 

ID	ID_revision	Status	ModificationDate
1	1	A	01.01.2018
1	2	B	01.01.2018
2	1	B	01.01.2018
2	2	C	02.01.2018
3	1	B	02.01.2018
4	1	A	02.01.2018
4	2	B	03.01.2018
4	3	C	03.01.2018
1	3	C	03.01.2018
5	1	A	04.01.2018

Thanks 

[v-lili6-msft]

hi, @Anonymous 

What is the logic of these three measure? 

Just from the excel screenshot, It’s difficult to understand the logic of your expected output.

Could you please explain the logic with your sample data?

Regards,

Lin