Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Sorry, repeating as my first question was marked as spam. I removed the link which I assume is why my post was removed.
I have been trying to follow this link to create a list in Power BI. For a little background, I am attempting to create a dataset within Power BI that has products, their list price, quantities sold, etc. But I would like to filter this by category and eventually by subcategory using AdventureWorks2014 Database. It was incredibly difficult to figure out a way to do this with step by step guides. (Are there any clear resources that discuss this?...I came across some questions on this forums and the answers pointed to a blog that wasn't of much help). I finally came across this link that provided me a little clarity. I have to create a list, I can't simply simply do a normal SQL query like the one I was sttempting to do, because when I select for Query when creating a parameter, the list does not show up. Below is my code, where AventureWorks2014 is the database, Production is the schema,
ProductCategory is the table and "Name" is the field I want to create a list from.
Update: I updated my source by clicking on the exact table I was referencing and my code has been changed to correctly reflect the dbo and table. New code below:
let Source = Sql.Database("localhost", "AdventureWorks2014"), Production_ProductCategory = Source{[Schema="Production",Item="ProductCategory"]}[Data], #"Added Custom" = Table.AddColumn(Production_ProductCategory, "ProductCategoryID", "Name"), CategoriesList = #"Added Custom"[ProductCategoryID], #"RemovedDuplicates" = List.Distinct(CategoriesList) in #"RemovedDuplicates"
New Error Message:
Expression.Error: We cannot convert the value "Name" to type Function. Details: Value=Name Type=Type
But I am encountering the new error above.
Solved! Go to Solution.
Not sure how your data exactly looks like, but you can try this one as a start:
let Source = Sql.Database("localhost", "AdventureWorks2014"), Production_ProductCategory = Source{[Schema="Production",Item="ProductCategory"]}[Data], #"Added Custom" = Table.AddColumn(Production_ProductCategory, "ProductCategoryID", each [Name]), CategoriesList = #"Added Custom"[ProductCategoryID], #"RemovedDuplicates" = List.Distinct(CategoriesList) in #"RemovedDuplicates"
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Not sure how your data exactly looks like, but you can try this one as a start:
let Source = Sql.Database("localhost", "AdventureWorks2014"), Production_ProductCategory = Source{[Schema="Production",Item="ProductCategory"]}[Data], #"Added Custom" = Table.AddColumn(Production_ProductCategory, "ProductCategoryID", each [Name]), CategoriesList = #"Added Custom"[ProductCategoryID], #"RemovedDuplicates" = List.Distinct(CategoriesList) in #"RemovedDuplicates"
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
105 | |
88 | |
74 | |
66 |
User | Count |
---|---|
126 | |
111 | |
100 | |
83 | |
71 |