Forum Discussion

Jan_DK's avatar
Jan_DK
Frequent Visitor
2 years ago
Solved

Get title from Azure DevOps 3 leves above

Hi   In Azure DevOps we are having a structure like this   Project 'ProjectTitle'      Epic         Feature              Product Backlog Item 'PBITitle', 'PBIDescription'   I use Odata to gr...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.

Jan_DK's avatar
Jan_DK
Frequent Visitor
2 years ago

Thanks 🐵