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('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?

 

 

Need Help

1 Reply

  • danextian's avatar
    danextian
    Super 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" )
)