Forum Discussion

Anonymous

Not applicable

3 years ago

Solved

New table based on a query

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...

v-yinliw-msft
3 years ago
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.

Icon for Community Support rank

Community Support

3 years ago

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.

Anonymous

Not applicable

3 years ago

I got this:

Expression.Error: Token Literal expected.

Details

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