Grouping by Item and status, selecting max value and datediff and flagging specific Status

[OP_1234]

Hello Everyone,

I'm new to power BI and would really appreciate your help.

I have the following sample dataset (this sample only relates to 1 item):

ID	Status	year-month	Item_Num	Days_In_Status
202212||11223344	Offered for sale	202212	11223344	212
202211||11223344	Offered for sale	202211	11223344	182
202210||11223344	Offered for sale	202210	11223344	152
202209||11223344	Offered for sale	202209	11223344	121
202208||11223344	Offered for sale	202208	11223344	91
202207||11223344	Offered for sale	202207	11223344	60
202301||11223344	Sold	202301	11223344	0
202206||11223344	Offered for sale	202206	11223344	29
202102||11223344	waiting	202102	11223344	11
202202||11223344	waiting	202202	11223344	11
202101||11223344	Rented	202101	11223344	32
202205||11223344	Rented	202205	11223344	92
202204||11223344	Rented	202204	11223344	60
202203||11223344	Rented	202203	11223344	31
202201||11223344	Rented	202201	11223344	197
202112||11223344	Rented	202112	11223344	166
202111||11223344	Rented	202111	11223344	135
202110||11223344	Rented	202110	11223344	105
202109||11223344	Rented	202109	11223344	74
202108||11223344	Rented	202108	11223344	44
202107||11223344	Rented	202107	11223344	12
202106||11223344	Rented	202106	11223344	107
202105||11223344	Rented	202105	11223344	77
202104||11223344	Rented	202104	11223344	46
202103||11223344	Rented	202103	11223344	16

For my analysis, I would like:

1. To select, for each item and status, the max value of 'days_In_Status' and date.

2. To sum the time difference between 'Offered to sale' and 'Sold' 

3. To flag, in an added column, the items that were rented and then sold.

Can someone please guide me to the right solution?

Thank you. 

[Anonymous]

Hi @OP_1234 

Can you share the expected output(may be in excel) which will help to solve this scenario?