Latest Enterprise DNA Initiatives

Groupby with max

I’ve created a table and I need just one line for each distinct Internal ID. So in the picture, I need one line because the internal ID on both lines are 12940287. How do I modify my code to accomplish this?

@Usates,

Try this. Add this above the GROUPBY statement:

VAR LeftPart = LEFT(‘Transaction Related’[Internal ID w Line ID], 8)

Then
VAR Result = GROUPBY statement with the highlighted portion below replaced by LeftPart

and then add

RETURN
Result

at the end.

  • Brian

1 Like