Forum Discussion
Calculated table to get earliest highest value?
I am trying to find the earliest occurances of the highest value in a given column. Here is the initial state of the data: Item Cost Date a1 1 01/01/2022 a1 3 01/05/2022 a1...
As an update, I tried deduping based on the columns that were causing me issues, but it didn't help.
Still getting the above error. Any ideas?
create a temporary table like
Tmp table =
ADDCOLUMNS (
SUMMARIZE ( 'Table', 'Table'[Item], 'Table'[Date] ),
"@num rows", CALCULATE ( COUNTROWS ( 'Table' ) )
)
that should help you identify any remaining duplicates.