Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hey Community,
So i'm using directquery mode And I need to delete rows that are (almost) identical, keeping the last row. Example below:
Source:
ID, Type , Type2,
1, A, a
1, A, b
1, B, a
Result:
1, A, b
1, B, a
So I delete One of the first two rows because ID And Type Are equal.
Any ideas How to get this Done?
Solved! Go to Solution.
Hi,@Anonymous
You can use a measure as visual level filter to meet your needs:
Create a measure like this after you got the sample:
Measure = RANKX(ALLEXCEPT('Table','Table'[ID],'Table'[Type]),CALCULATE(MAX('Table'[Type2])),,DESC)
Then you can put the measure in your visual to filter what you want.
Hope it helps.
Best Regards,
Caitlyn Yan
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi,@Anonymous
You can use a measure as visual level filter to meet your needs:
Create a measure like this after you got the sample:
Measure = RANKX(ALLEXCEPT('Table','Table'[ID],'Table'[Type]),CALCULATE(MAX('Table'[Type2])),,DESC)
Then you can put the measure in your visual to filter what you want.
Hope it helps.
Best Regards,
Caitlyn Yan
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
77 | |
76 | |
42 | |
30 | |
24 |
User | Count |
---|---|
97 | |
91 | |
52 | |
47 | |
46 |