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
NikhilChenna's avatar
NikhilChenna
Icon for Skilled Sharer rankSkilled Sharer
3 years ago

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!