Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello everyone, please I need a help, I want to add a new column "Column 4" in front of each row I habe to see the value of the column Title, As you can see below I need to add the column4 "each Departme has one title", I have tried to add a column with lookupvalue (if blank) but it's not working.
Thank you in advance.
Solved! Go to Solution.
Hi,
I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.
It is for creating a new column.
Title Name CC =
SUMMARIZE (
FILTER (
Data,
Data[Department] = EARLIER ( Data[Department] )
&& Data[Title] <> BLANK ()
),
Data[Title]
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi,
I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.
It is for creating a new column.
Title Name CC =
SUMMARIZE (
FILTER (
Data,
Data[Department] = EARLIER ( Data[Department] )
&& Data[Title] <> BLANK ()
),
Data[Title]
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Thank you a lot, That's what I was looking for.