topic How To Find The Specific Value In Power Pivot For Specific Text? in DAX Commands and Tips

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

BAFreedom — Sun, 26 Jun 2022 17:21:44 GMT

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:

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

tamerj1 — Sun, 26 Jun 2022 17:15:20 GMT

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.

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

BAFreedom — Sun, 26 Jun 2022 17:22:41 GMT

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

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

tamerj1 — Sun, 26 Jun 2022 17:35:54 GMT

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

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

BAFreedom — Sun, 26 Jun 2022 17:48:32 GMT

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