How to Create a New Table from existing table using IN POWER QUERY NOT IN Data model

How to Create a New Table from existing table using EDIT QUERY in POWER BI? IN POWER QUERY NOT IN DATA MODEL Example : Table A Name ID Amount Product surya 111 324 Milk surya 11...

v-xuding-msft

6 years ago

Hi Anonymous ,

I also use the option "Group By" to do it. You could have a try.

let
    Source = Table,
    #"Grouped Rows" = Table.Group(Source, {"Name", "ID"}, {{"Count", each Table.RowCount(Table.Distinct(_)), Int64.Type}}),
    #"Removed Columns" = Table.RemoveColumns(#"Grouped Rows",{"Count"})
in
    #"Removed Columns"

Forum Discussion

How to Create a New Table from existing table using IN POWER QUERY NOT IN Data model

Related content

Lakehouse Table Generate Create Table

Create new table

Cannot create liquid clustering on existing unpartitioned table

Create a new table from columns from existing tables

Create rows from 2 tables