Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
37 | |
25 | |
19 | |
14 | |
8 |
User | Count |
---|---|
68 | |
48 | |
45 | |
18 | |
15 |