Forum Discussion
IF formula
Hi I'm trying to comeup with a formula with a condition
e.g
if Classification = Sampling point and Product <> General then Business Function for the record = Business Function Value of its Parent record.
I mean if for a record X its parent = ST and ST as an attribute Business Function with value = HI then
if Classification = Sampling point and Product <> General then X = HI.
Really appreciate if any one can help to execute this formula.
KInd Regards,
Chiru
3 Replies
Hey chiru5262 ,
Regarding your question, I have to admit that I have my problems understanding your requirement.
Please consider to create a pbix file that contains sample data, but still reflects the data model (https://docs.microsoft.com/en-us/learn/modules/design-model-power-bi/).
You can use this to enter data directly in Power BI Desktop: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-enter-data-directly-into-desktop. Upload the pbix file to onedrive or dropbox and share the link. If you are using Excel to create the sample data, share the xlsx as well.
Create columns that contain the expected results, use the sample data to explain how the result is derived from the sample data.Regards,
Tom
chiru5262 ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Hi chiru5262 ,
Something like
Business Function = IF ( [Classification] = [Sampling point] && [Product] <> [General], [Parent record] )The question is what's the [parent record] in your table?
Can you show more details?
Best Regards,
Jay
