Tableau like Fixed Formula (Extract Normalized Data)

[Germj]

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('Oracle 001 - Latest Data','Oracle 001 - Latest Data'[Value])

,'Oracle 001 - Latest Data'[Label]="Date")

I'd like to see this value across the entire list for that single project. Not just where that field is, and then format it as a date?

[danextian]

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" )
)