I need to create a measure to Parent name using id=parentid join.
Create a Measure "Parent Name".
Can't modify the Dataset due to company policy.
Is there a way to calculate the measure?
Solved! Go to Solution.
Ahh, I had done mine as a measure. Because you said you couldn't modify the data set I thought you couldn't add a column. I have updated the calculated column to work and also added in the measure in the attached file.
Give this a try.
Parent Name = VAR RowParent = SELECTEDVALUE ( 'Your Table'[Parent_id] ) RETURN IF ( ISBLANK ( RowParent ), "n/a", LOOKUPVALUE ( 'Your Table'[Name], 'Your Table'[id], RowParent ) )
Strange. I tried your solution, why mine is showing n/a?
In your table, is ID a number and Parent ID text?
oops, I am not the one who posted. I gaveit a try because I want to learn.
And you did not fail me, I really did learn something new from you today.
Thank you @jdbuchanan71 ! You are awesome!!
Check out the changes to the Power BI Community announced at Build.
Find out more about the May 2023 update.