Forum Discussion

Germj's avatar
Germj
Frequent Visitor
3 years ago

Tableau like Fixed Formula (Extract Normalized Data)

Hi, I have a set of data that is completely normalized. I'm trying to create a column that pulls out an individual "label". This is where I'm at right now.   Date = CALCULATETABLE( SUMMARIZE('Ora...
Need Help
danextian's avatar
danextian
Icon for Super User rankSuper User
3 years ago

Hi Germj ,

 

Try this as a calculated column but change the table and column names accordingly:

=
CALCULATE (
    MAX ( Data[Value] ),
    FILTER ( ALLEXCEPT ( Data, Data[projectnumber] ), Data[Label] = "Date" )
)