Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Lookup Value from Dimension table

Hi, how to create a DAX to have column "Version" and "Upgrade" in Fact table?   Dimension Table: Product Attribute Name Attribute Value A Version V-1 A Upgrade U-2 B Version V-...
Need Help
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi Anonymous 

    Please try

    Version = CALCULATE ( MAX ( TableA[Attribute Value] ),TableA[Attribute Name] = "Version" )
    Upgrade = CALCULATE ( MAX ( TableA[Attribute Value] ), TableA[Attribute Name] = "Upgrade" )

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi ribisht17 , i am not sure how to create the column as I need to pull the attribute name as column name.