Comparing multiple rows in same order

[json12]

I want to compare condition types for each order. There are 8 distinct conditions types.

Sales Order #	Line Item (on sales order)	Condition Type	Condition Status (Active or Inactive)
1111111111	1	con 1	A
1111111111	1	con 2	I
1111111111	1	con 3	I
1111111111	2	con 4	I
1111111111	2	con 2	A
1111111111	2	con 3	A
2222222222	1	con 1	A
2222222222	1	con 2	I

Output should show:

Sales Order #	Line Item (on sales order)	Output
1111111111	1	con 1 - active  con 2 - inactive con 3 - inactive
1111111111	2	con 2 - active con 3 - active con 4 - inactive
2222222222	1	con 1 - active con 2 - inactive

From this, I want to be able to count orders where (con 1 = active) and (con 2 = inactive or con 3 = inactive)

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.