Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Community,
Here i shared my table chart.. here i am getting duplicate Item descriptions because their id's are different. now what i want is if same item description is present in multiple times i want to show end date presented item description. i am not able to get how to achieve this... Some of item descriptions doesn't have end date at that time i want to show latest start date item description. whenever end date will come it will show start and end date presented item description
Please help me out from this
Thank you in advance
B V S S
Hello @Anonymous
Create an Calculated Column with the below DAX
Hi @Anonymous ,
Thank you for your response.. But I have data for Blank End dates also See below image. if two duplicate name comes at that i want to take that criteria otherwise i want to show all if end date is blank also
Thank you in advance
Regards,
B V S S
@Anonymous
Have you try the 'Remove Duplicates' option from 'Query Editor' ?
Try this and let me know
Nandri
Hi @Anonymous,
We can't remove like that because those duplicate names id's are different
@Anonymous
Try with Summarize table DAX function as like below
Hi @Anonymous,
I tried i am getting this error.. i am not understanding what is my mistake.. and my dates are in mm/dd/yyyy format
Thank you in advance... Waiting for your more suggestions
@Anonymous
Can you please share either the source file or PBIX file ? Let me try to fix that and revert back. 🙂
right-click on values and choose the agg option you want and see, if it resolve your issue.
Hi @amitchandak
Thank you for your response.. But i didn't get your solution. can you please explain little mor
Thank you in advance
Hi,
Have you tried putting EndDate[]<> BLANK()
Hi @Anonymous,
Thank you for your response.. But I have data for Blank End dates also See below image. if two duplicate name comes at that i want to take that criteria otherwise i want to show all if end date is blank also
Thank you in advance
Regards,
B V S S
User | Count |
---|---|
103 | |
88 | |
78 | |
71 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |