Groupby with max

Usates · February 22, 2021, 11:06pm

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?

BrianJ · February 22, 2021, 11:31pm

@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