
Announcements
GroupBy(
AddColumns(
ISK_Jails,
"SSNMatchScore",
If(
CountIf(
ISK_Consumers,
SSN = SocialSecurityNumber
) > 0,
3,
0
),
"FirstName",
First(Split(Name," ")).Result,
"MiddleName",
First(LastN(Split(Name," "),2)).Result,
"LastName",
Last(Split(Name," ")).Result
),
"cr4d3_name",
"FirstName",
"MiddleName",
"LastName",
"cr4d3_transtype",
"SSNMatchScore",
"cr4d3_socialsecuritynumber",
"cr4d3_recordid","cr4d3_active",
"GroupedRecords"
)If I want to include a Filter on the above statement, what is the proper syntax or placement for the Filter? I have a column in the dataverse table that is cr4d3_active and I want to filter where only Active=true. I have tried putting Filter at the beginning and then right after the GroupBy but neither is working and perhaps my logic is flawed also. Is there a better best-practice for this? Thanks for the information.
Hello @iskguy ,
I think you can put your filter just around your AddColumn :
GroupBy(
Filter(
AddColumn(...),
//Filter
)
)
Tell me if It's works 🙂
Henri