topic Re: New table based on a query in DAX Commands and Tips

New table based on a query

Anonymous — Sat, 12 Nov 2022 16:03:23 GMT

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}})

#"Grouped rows"

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

Re: New table based on a query

AnkitKukreja — Sat, 12 Nov 2022 16:47:34 GMT

Hi! Anonymous

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

Re: New table based on a query

Anonymous — Sat, 12 Nov 2022 19:20:10 GMT

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

Re: New table based on a query

v-yinliw-msft — Mon, 14 Nov 2022 02:26:45 GMT

Hi Anonymous ,

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.

Re: New table based on a query

Anonymous — Mon, 14 Nov 2022 19:35:47 GMT

I got this:

Expression.Error: Token Literal expected.

Details

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

Re: New table based on a query

v-yinliw-msft — Wed, 16 Nov 2022 09:26:04 GMT

Hi Anonymous ,

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.

Re: New table based on a query

Anonymous — Fri, 18 Nov 2022 11:51:12 GMT

Hi,

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

Re: New table based on a query

v-yinliw-msft — Fri, 25 Nov 2022 06:36:48 GMT

Hi Anonymous ,

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.

Re: New table based on a query

NikhilChenna — Fri, 25 Nov 2022 07:12:20 GMT

Hi Anonymous , 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!