New table based on a query

[Kenjoswe]

Hi,

I'm new to PowerBI Web and would like to create a new table based on the result of a query.

This is what I have:

let

  Source = INTAKT_VIEW,

  #"Grouped rows" = Table.Group(Source, {"Period"}, {{"Sum", each List.Sum([Intakt]), type nullable number}})

in

  #"Grouped rows"

How can I create a new table with two columns Period sumIntakt?

[Kenjoswe]

Two tables. How can I save the aggregated table?

Original table

Period	SumIntakt
1	20
1	20
2	30

Aggregated table

Period	SumIntakt
1	40
2	30

[NikhilChenna]

Hi @Kenjoswe , The best solution is the below.

By creating a measure.

 Measure = CALCULATE(SUM('Table'[SumIntakt]),ALLEXCEPT('Table','Table'[Period]))

Regards,

Nikhil Chenna

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!

[v-yinliw-msft]

Hi @Kenjoswe , 

There are three methods to solve this question:

Method 1:

New a measure:

Sumlntakt1 = CALCULATE(SUM('Table'[SumIntakt]),ALLEXCEPT('Table','Table'[Period]))

Method 2:

Method 3:

New a table:

TableS = SUMMARIZE('Table','Table'[Period], "Sumlntakt", SUM('Table'[SumIntakt]))

Hope this help you.

Here is my PBIX file:

Best Regards,

Community Support Team _Yinliw

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

[Kenjoswe]

I got this:

Expression.Error: Token Literal expected.

Details

TableS = SUMMARIZE('INTAKT_VIEW','INTAKT_VIEW'[Period], "Sumlntakt", SUM('INTAKT_VIEW'[SumIntakt]))

[v-yinliw-msft]

Hi @Kenjoswe ,

I think you use the formula in the Power Query, you should use it in the Desktop -> New table:

Best Regards,

Community Support Team _Yinliw

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

[Kenjoswe]

Hi,

I'm using the webversion so I don't have that function: 

[v-yinliw-msft · Accepted solution]

Hi @Kenjoswe ,

You can try this method:

Use the Group By:

The result is:

Or you can download the Power BI Desktop:

Get Power BI Desktop - Power BI | Microsoft Learn

Hope this helps you.

Best Regards,

Community Support Team _Yinliw

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

[AnkitKukreja]

Hi! @Kenjoswe 

The problem is not clear. Can you please share sample data and expected result?