Forum Discussion

SevsBo's avatar
SevsBo
Responsive Resident
3 years ago

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...
Need Help
SevsBo's avatar
SevsBo
Responsive Resident
3 years ago

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?

  • johnt75's avatar
    johnt75
    Super User
    3 years ago

    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.