Lookup Value from Dimension table

[PBI_newuser]

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-2
B	Upgrade	U-3
C	Version	V-1
C	Upgrade	U-1

Fact Table:

Product	Account	Country	Version	Upgrade
A	Company X	USA	V-1	U-2
B	Company Y	Canada	V-2	U-3
C	Company Z	Germany	V-1	U-1

[tamerj1 · Accepted solution]

Hi @PBI_newuser 

Please try

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

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

[ribisht17]

@PBI_newuser 

Please refer Solved: Lookup value from a table - Microsoft Power BI Community

Regards,

Ritesh

[PBI_newuser]

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