Forum Discussion

kmcardle's avatar
kmcardle
Helper I
4 years ago
Solved

My Query seems to always return a Function or an Error

First, thank you all for the support you provide on this forum.  It's been a very great experience for a new Power BI developer like me.   I'm currently trying to add some custom columns to my data...
  • PhilipTreacy's avatar
    PhilipTreacy
    4 years ago

    Hi kmcardle 

     

    Download my example PBIX file

     

    Do you want the result to look like this:

     

    If so then you can create a new column with this code

    let _id = [ID] in List.Count(List.Select(#"Changed Type"[ID], each _ = _id))

     

    Regards

     

    Phil

  • kmcardle's avatar
    kmcardle
    4 years ago

    Wow. Exactly what the doctor ordered.  Thank you!

     

    Kevin