Forum Discussion

JoeHazelton's avatar
JoeHazelton
Frequent Visitor
4 years ago

Summary Task / Parent Task Name roll down

Dear Community,   I am hoping that someone is able to assist.   I have a large collection of Projects where the Summary Task Name holds most of the information for that scheme on this line (task ...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
4 years ago

JoeHazelton Hard to say exactly, what does your source data look like? Maybe a Merge operation? Alternatively you could write measures or calculated columns for this like LOOKUPVALUE, MAXX(FILTER(...),...), etc.?

JoeHazelton's avatar
JoeHazelton
Frequent Visitor
4 years ago

Hi Greg,

 

Thanks for coming back to me. I have attached a screenshot of transform page if that helps in anyway. I am new to BI and have only created a few calculated columns previously.

 

Thanks.

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    HI JoeHazelton,

    Perhaps you can try to use URL conversion into the OData connector to apply custom operations then you can apply fill functions on these records.

    Documentation · OData - the Best Way to REST

    Regards,

    Xiaoxin Sheng