Distinct according to another value

(0) Share

Report

Posted on by kgiles123

224

First thank you for any help you can provide!

I have multiple identical 'Group Time' but I would like to make 'Group Number' the distinct value and return multiple 'Group Time' for when different 'Group Number' exist.

Here's an example:

Group Number Group Time

1 1:00

2 1:00

3 1:00

Desired Result:

1:00

Here is what I have for a formula:

Distinct(Sort(Filter('Repository', 'Group Date' = '1Meeting Date'.Selected.Value),'Group Date'),'Group Time')

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

cha_cha 4,932 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hello @kgiles123

What if the data is this:

Group Number Group Time

1 1:00

2 1:00

2 2:00

3 1:00

What would be the desired result?

Was this reply helpful? Yes No
cha_cha 4,932 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hello @kgiles123

The solution formula would be like this:

Ungroup( ShowColumns( AddColumns( GroupBy(Filter('Repository', 'Group Date' = '1Meeting Date'.Selected.Value),"Group Number","GroupNum"), "Group Time",Distinct(GroupNum,TimeValue('Group Time')) ),"Group Time" ),"Group Time" )

Was this reply helpful? Yes No
Verified answer

kgiles123 224 on at

Like (0)

Report
Copy link

Link copied!

In that case I would like to see all group times. Thank you!

Was this reply helpful? Yes No