cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
skiper26 Frequent Visitor
Frequent Visitor

Groupby Or Summarize

Hi all

I want to calculate formulas on the last column which is as under

 

example.PNG

 

I created groupping and drag these fields into Power BI work area, YEar, Month, OrderStatusTitle and Total Order(Count of order) into a matrix table. which is as under

example1.PNG

 

How to calculate those three formulas in the last column of excel file. From the groupped items.. I have groupped items of column "OrderStatusTitle Group" and want to apply aggregation on those grouped values...

1 REPLY 1
v-evelk Member
Member

Re: Groupby Or Summarize

Hi,

 

Power BI just applys grouping for categories and some aggregation functions for measures.

If you need more specific calculation you will probably need to use DAX -- it is a feature of Power BI Desktop.

 

All questions regarding DAX you can ask in the Desktop thread.

 

Kind Regards,

 

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com