Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Select columns starting with

Hi PowerBI community,   I am trying to assist one of my colleagues with a powerbi report pulling data from Jira through their documented API.   For a reason not worth explaining, the list of colu...
Need Help
  • mahoneypat's avatar
    mahoneypat
    6 years ago

    Yes.  If you look at the M code, the column names to be combined is a list.  You could try putting this M code in place of the existing list (for example for the Assumptions columns)

     

    List.FindText(Table.ColumnNames(#"Removed Other Columns1"), "Assumptions")

     

    That would make a list of all the column names that contain Assumptions.  As it grows, so will that list.

     

    If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

    Regards,

    Pat

mahoneypat's avatar
mahoneypat
Microsoft Employee
6 years ago

Yes.  If you look at the M code, the column names to be combined is a list.  You could try putting this M code in place of the existing list (for example for the Assumptions columns)

 

List.FindText(Table.ColumnNames(#"Removed Other Columns1"), "Assumptions")

 

That would make a list of all the column names that contain Assumptions.  As it grows, so will that list.

 

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks very much Pat, it worked perfectly