Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Pandadev
Post Prodigy
Post Prodigy

summarised table in query editor comma missing

Hi I have 75 tables which have the following columns matched taht I want to add a summarised table to in query editor.

The columns are QC Check and Researcher

Is it possible to create a table showing the QC Check and count of rows per researcher

 

i tried to research this but am getting an error saying comma missing  , plus some of the tables have spaces how would they be added , would it be in this format [my table]

= let
Source = Table.Combine({Table.SelectColumns(24_not_followed_by_ZZ, {"QC Check", "Researcher"}),
Table.SelectColumns(41_followed_by_Purchased, {"QC Check", "Researcher"}),
Table.SelectColumns(74_not_followed_by_ZZ, {"QC Check", "Researcher"}),
Table.SelectColumns(A3_Followed_by_99, {"QC Check", "Researcher"})}),

#"Removed Duplicates" = Table.Distinct(Source)
in

#"Removed Duplicates"

 

The output I was looking for

QC Checker                          Researcher  Rows

24 not followed by ZZ         DC               4

24 not followed by ZZ         BA               2

41 followed by Purchased   DC               9

41 followed by Purchased   RM              22

1 ACCEPTED SOLUTION
edugoncalves
Resolver I
Resolver I

Hi @Pandadev ,

You're wrongly mentioning the tables, by default, it should be like this: #"Table_Name"

With that in mind, you have the corrected code here:

let
Source = Table.Combine({Table.SelectColumns(#"24_not_followed_by_ZZ", {"QC Check", "Researcher"}),
Table.SelectColumns(#"41_followed_by_Purchased", {"QC Check", "Researcher"}),
Table.SelectColumns(#"74_not_followed_by_ZZ", {"QC Check", "Researcher"}),
Table.SelectColumns(#"A3_Followed_by_99", {"QC Check", "Researcher"})}),

#"Removed Duplicates" = Table.Distinct(Source)
in

#"Removed Duplicates"

 

Best Regards,

Eduardo

View solution in original post

3 REPLIES 3
Pandadev
Post Prodigy
Post Prodigy

I managed to work it out myself thanks for your help on thie , I added 

#"Grouped Rows" = Table.Group(Source, {"QC Check", "Researcher"}, {{"Rows", each Table.RowCount(_), Int64.Type}})
in
#"Grouped Rows"

edugoncalves
Resolver I
Resolver I

Hi @Pandadev ,

You're wrongly mentioning the tables, by default, it should be like this: #"Table_Name"

With that in mind, you have the corrected code here:

let
Source = Table.Combine({Table.SelectColumns(#"24_not_followed_by_ZZ", {"QC Check", "Researcher"}),
Table.SelectColumns(#"41_followed_by_Purchased", {"QC Check", "Researcher"}),
Table.SelectColumns(#"74_not_followed_by_ZZ", {"QC Check", "Researcher"}),
Table.SelectColumns(#"A3_Followed_by_99", {"QC Check", "Researcher"})}),

#"Removed Duplicates" = Table.Distinct(Source)
in

#"Removed Duplicates"

 

Best Regards,

Eduardo

Thanks that worked , is there a way to just get the cound of Researcher

like

24 not followed by ZZ         DC               4

24 not followed by ZZ         BA               2

41 followed by Purchased   DC               3

41 followed by Purchased   RM              2

 

at the moment it is showing 

24 not followed by ZZ         DC

24 not followed by ZZ         DC

24 not followed by ZZ         DC

24 not followed by ZZ         DC

24 not followed by ZZ         BA

24 not followed by ZZ         BA

41 followed by Purchased   DC

41 followed by Purchased   DC

41 followed by Purchased   DC

41 followed by Purchased   RM

41 followed by Purchased   RM

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.