Hi @novicenovice,
Could you please share a bit more about the ID column and the PERIOD column in your SP list?
Is the ID column a System column or a custom column? Is the ID column a Number type column?
I assume that the ID column is a Number type column within your SP list, I have made a test on my side, please take a try with the following workaround:
Set the Items property of the Data table control to following formula:
DropColumns(
AddColumns(
GroupBy(SortByColumns('20180728_case11',"OData__x0049_D1",Ascending),"PERIOD","GroupData"),
"ID",Last(GroupData).OData__x0049_D1,
"CUSTOMER",Last(GroupData).CUSTOMER,
"IND_VALUE",Last(GroupData).IND_VALUE
),
"GroupData"
)
Note: The "OData__x0049_D1" represents the ID1 column in my SP list data source (on your side, it is ID column).
On your side, please type the following formula:
DropColumns(
AddColumns(
GroupBy(SortByColumns('YourSPListDataSource',"ID",Ascending),"PERIOD","GroupData"),
"ID",Last(GroupData).ID,
"CUSTOMER",Last(GroupData).CUSTOMER,
"IND_VALUE",Last(GroupData).IND_VALUE
),
"GroupData"
)
Best regards,
Kris
