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

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
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" )