Unanswered

Sort filter Distinct on a table

(0) Share

Report

Posted on by Wilder16261626

Hi, I have this code to feed a table when toggle = true or False. The toggle name is: LbVisible.

If ( LbVisible.Value = false; 
Sort( Filter( INCO_REQUESTS; Status = "Submitted for Action" And Request_Type <> "NO TARIFF" And IsBlank(Email) ); Submitted_Time; Ascending ); 
Sort( Filter( INCO_REQUESTS; Status = "Submitted for Action" And IsBlank(Email) ); Submitted_Time; Ascending ) 
)

Now i would like to add Distinct value only, cause right now, i have duplicated rows.

How can i do that?

Thank you

Categories:

Power Query

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Wilder16261626 16 on at

Like
a
(0)

Report
Copy link

Link copied!

For some reason, the minute I add "Distinct", that's when I get an error. If I remove the Distinct portion of the code you gave me, it works perfectly. I will try again and get back to you, but for now, no luck.

Was this reply helpful? Yes No
Wilder16261626 16 on at

Like
a
(0)

Report
Copy link

Link copied!

I tried again, and when I add the Distinct code piece, I still receive the same errors:
I'm confused as to why this is happening.

Was this reply helpful? Yes No
Wilder16261626 16 on at

Like
a
(0)

Report
Copy link

Link copied!
For some reasons, i'm still having all those errors

What if i use First and groupBy to replace the Distinct?

Ex:
First( Filter( INCO_REQUESTS, Status = "Submitted for Action" And Request_Type <> "NO TARIFF" And IsBlank(Email) ) )
It gives me the first record only, but if i group by 2 columns value, would that also do it?
Ex: Group by "From" and "To" columns?

Would i have to put my GroupBy at the beginning?

Was this reply helpful? Yes No
Wilder16261626 16 on at

Like
a
(0)

Report
Copy link

Link copied!
I think i was able to make it work like this:
GroupBy( Filter( INCO_REQUESTS, Status = "Submitted for Action" And Request_Type <> "NO TARIFF" And IsBlank(Email) ), "From", "To" )
, but i will continue to test

Was this reply helpful? Yes No