Distinct Values with Variable Parameters/Values

[marslan]

Hi, I am new to Power-BI and I have a Union Table of different Part Numbers and SRC (Column 02 and Last column) that have duplicate values. I want to see for a single unique part number how many SRC variation are in there?

For instance in below table, Part Number UC-H19 is allocated with SRC 160 and 500. I want a table which shows UC-519 and other column should show both SRC ifront of it? I did it in Excel but the data is too large to get into excel so I need help for Power-Bi.

 

[Anonymous]

Hi @marslan ,

I don't quite understand what you mean, can you explain the output you expect with a sample, thanks in advance.

Do you want to create parameters for filtering at the data source and import only the expected results into Power BI?
Or do you expect to import the content into Power BI and then filter it?

Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[marslan]

Anyone?