Forum Discussion

BAFreedom's avatar
BAFreedom
Helper I
4 years ago
Solved

How To Find The Specific Value In Power Pivot For Specific Text?

I know this is a PowerBI community, but I will eventually be using PowerBI for this (after I solve this problem with Power Pivot), and this is urgent.  I want to do a calculated field in "sheet 1" s...
  • tamerj1's avatar
    tamerj1
    4 years ago

    BAFreedom 

    I guess you have many to one relationship between Sheet1 and Sheet2. Please use

    Price = 

    IF ( Sheet1[Category] = "Category 1" || Sheet1[Category] = "Category 2", RELATED ( Sheet2[Cost] ) )

     

tamerj1's avatar
tamerj1
Community Champion
4 years ago

BAFreedom 

I guess you have many to one relationship between Sheet1 and Sheet2. Please use

Price = 

IF ( Sheet1[Category] = "Category 1" || Sheet1[Category] = "Category 2", RELATED ( Sheet2[Cost] ) )

 

BAFreedom's avatar
BAFreedom
Helper I
4 years ago

WOW! Thank you so much for your help. I asked around, and nobody was able to get it but you. Thank you!!