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,
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
Hi @Amardeep100115,
Is that possible to achieve your goal by slicer directly? If it doesn't meet your requirement, kindly share your sample data and excepted result to me.
Regards,
Frank
Hi Frank,
Please find the below table for your reference.
in below table i have 143 Rows, in my data product data is having duplicates as well., with different "Target Expiry Date".
Here i wish to sort data by most recent "target expity date " without loosing product ID count which is 143. also please note i have multipal sheets whicj linked with Product ID each other. also i am not getting 143 rows data from mapped table it shows less data then expected rows 143. please guide me on this as well.
Thank you
Product ID | Region | Country | City | Lease End Date | Project QTR-FY | Target Expiry Date | Type | STATUS | Rank |
ABC_PF1062 | CALA | PANAMA | PANAMA CITY | 31-Oct-18 | MD | NO ACTION | 4 | ||
ABC_PF1081 | APAC | SINGAPORE | SINGAPORE | 31-Jul-19 | Q4-2018 | 2-Jul-18 | About to Closing | COMPLETE | 5 |
ABC_PF1081 | APAC | SINGAPORE | SINGAPORE | 31-Jul-19 | Q4-2020 | 30-Sep-20 | Renew | Z-REJECTED | 1 |
ABC_PF1237 | USA | UNITED STATES OF AMERICA | NORFOLK | 31-Oct-20 | MD | NO ACTION | 4 | ||
ABC_PF4452 | USA | UNITED STATES OF AMERICA | OKLAHOMA CITY | 20-May-18 | Q3-2018 | 13-Jun-18 | About to Closing | COMPLETE | 5 |
ABC_PF4499 | USA | UNITED STATES OF AMERICA | COPPELL | 7-Jul-19 | Q4-2019 | 7-Jul-19 | Close | APPROVED | 3 |
Hi Frank and G
Could you please guide me on my query?
I eagarly want to knock out this task.
Please guide me
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |