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.
Hi There,
Please guide me on below query Please
I have a table and would link to filter this table with rank according to date and display data without losing product count. If there are multiple products are having same lease end date and different critical date then show only upcoming date details with same product count
Product ID | Total Sale | Project Timeline QTR-FY | Critical Date | Lease End Date |
0071 | Q4-2018 | 05/09/19 | 11/09/19 | |
1062 | 07/31/19 | 10/31/18 | ||
1081 | $112,835 | Q4-2018 | 05/31/18 | 07/31/19 |
1081 | $112,835 | Q4-2020 | 07/31/22 | 07/31/19 |
1237 | $6,470 | 04/30/19 | 10/31/20 | |
4452 | $13,315 | Q3-2018 | 01/31/19 | 05/20/18 |
4499 | $274,681 | Q4-2019 | 07/07/19 | 07/07/19 |
6216 | $29,218 | Q1-2021 | 10/30/20 | 10/30/20 |
6218 | $221,176 | Q1-2021 | 10/30/20 | 10/30/20 |
6492 | 05/31/21 | 05/31/21 |
Hi @Amardeep100115,
From your description, I could not understand what your desired result? Could you please offer me more information or post your desired result picture if possible?
Regards,
Daniel He
HI There,
Sorry for not replying late.
I wish to filter upcoming project by project date in the below table i have highlighted the part where the one project is completed and another is upcoming. i wish to be see upcoming project and another should not be in table but it shouuld be at bottum of the table or get filtered by date. one thing need to be keep in mind that I have 143 Project rows and uniqe ID is 129 which should not get disturbed.
Hoope you got my requirement
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 |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |