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:

ProductAttribute NameAttribute Value
AVersionV-1
AUpgradeU-2
BVersionV-2
BUpgradeU-3
CVersionV-1
CUpgradeU-1

 

Fact Table:

ProductAccountCountryVersionUpgrade
ACompany XUSAV-1U-2
BCompany YCanadaV-2U-3
CCompany ZGermanyV-1U-1
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" )

3 Replies