Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

SUMMARIZE error - The Expression refers to multiple columns.

Good Morning.     I have a connection between PowerBI and Jira (our internal help desk) and through that connection, our service types are passed over but are passed over as a code vs. the actual t...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    Ok, finally figured it out that I wasn't trying to build the summary as a table.  Not sure how I missed it before but I finally caught it and I have it working now.  

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Let's see if this helps any.  Attached is a screenshot of my data showing the key column, the original pull from the Jira platform with raw data (Customer_Request_Type) and my new column (ServiceType).  This is from the Power Query Builder.

  

 

Here is the code I used to convert what is in Customer_Request_Type to what you see in the column ServiceType:  

 

ServiceType = Text.Replace(Text.Replace(Text.Replace(Text.Replace(Text.Replace(Text.Replace(Text.Replace(Text.Replace(Text.Replace(Text.Replace(Text.Replace(Text.Replace(Text.Replace([Customer_Request_Type], "isdd/461d0f58-1793-429b-a5e6-e043252915f2","License Request"), "isdd/8781bf07-ccfd-48fc-a2e6-4247e4b96672", "iMIS or CRM Issues"), "isdd/a04cd085-d7cd-43ff-9b77-44593049cf07", "Zoom/Ring Central Issue"), "isdd/compsupport", "Device Support"), "isdd/d0134297-ed98-433f-9d9e-8c746f31b563", "Report Requests"), "isdd/fd1d8a0c-59bb-44f9-ac49-94994a3fdb74", "Computer Program Support"), "isdd/getithelp", "Email Submittal"), "isdd/guestwifi", "Wi-Fi/Internet Support/VPN"), "isdd/newaccount", "User Account Management"), "isdd/newsoftware", "Request New Stuff"), "isdd/4d19144d-4a5a-49e3-8d4d-2ab756f013cb", "Request MELG Kit/Zoom Cart"), "isdd/bd10d23a-1166-4abd-afe4-94cdeed9bc7a", "Onboard Employee"), "isdd/da0434d1-42e6-4c71-bfad-29ea96d7675a", "Offboard Employee")

 

Kind of ugly but I have no other way to get this from the Jira PowerBI Connector as this is a custom field and that connection is limited.  I have to assume the problem is based on how this column ServiceType was created and that is why the Summarize isn't working so I am open to suggestions.