Forum Discussion

Anonymous's avatar
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's avatar
    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.

     

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Two tables. How can I save the aggregated table?

Original table

Period 

SumIntakt

 

120
120
230

 

Aggregated table

PeriodSumIntakt
140
230
v-yinliw-msft's avatar
v-yinliw-msft
Icon for Community Support rankCommunity 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's avatar
    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]))
    • v-yinliw-msft's avatar
      v-yinliw-msft
      Icon for Community Support rankCommunity Support
      3 years ago

      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.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hi,

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