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" such that it returns the price of service for only Category 1 and Category 2 options, and leave everything else (Category 1A, Category 3, etc.) blank in a new price column (sheet 1).

How do I go about this? I spent many hours trying... Thanks.

 

Here's the file: https://www.dropbox.com/s/088kel5c2jlo1z0/June%2026%20Power%20Pivot%20Question.xlsx?dl=0

Here are screenshots (I made the data to protect confidential information).

Sheet 1:

Sheet 2:

 

  • 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] ) )

     

4 Replies

  • 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!!

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    Hi BAFreedom 

    no worries it the same as power bi. Would you please share a screenshot as I'm currently accessing the forum through my mobile only. 

    • BAFreedom's avatar
      BAFreedom
      Helper I
      4 years ago

      tamerj1  Thanks for the reply. I just posted screenshots in the original message. Please let me know if you need anything else.