Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Hi @OP_1234
Can you share the expected output(may be in excel) which will help to solve this scenario?
User | Count |
---|---|
57 | |
22 | |
18 | |
16 | |
11 |
User | Count |
---|---|
85 | |
54 | |
39 | |
21 | |
18 |