Forum Discussion
Get title from Azure DevOps 3 leves above
Hi, Jan_DK
Yes, you need to New Column. you can refer to my DAX formula:
New Column to be define = SWITCH ( TRUE (), 'WorkItems'[Title] = "My first PBI", "My first project", 'WorkItems'[Title] = "My second PBI", "My second project", BLANK () )This is the result:
I hope it will help you.I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Fen Ling,
Thanks for reply, you almost read my mind 🐵
A bit more information
My masterdata is in the same table but mixed in the same colums.
See example file attached where the tabel looks like this
And i would like it to look like this where there mig should be a new coloum defined i guess?
Hi, Jan_DK
Yes, you need to New Column. you can refer to my DAX formula:
New Column to be define =
SWITCH (
TRUE (),
'WorkItems'[Title] = "My first PBI", "My first project",
'WorkItems'[Title] = "My second PBI", "My second project",
BLANK ()
)
This is the result:
I hope it will help you.
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks 🐵