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)

Wilder16261626 16 on at

Like (0)

Report

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 (0)

Report

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 (0)

Report
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 (0)

Report
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