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.

     

     

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: 

 

  • v-yinliw-msft's avatar
    v-yinliw-msft
    Icon for Community Support rankCommunity Support
    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.