Groupby Or Summarize

[Anonymous]

Hi all

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

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

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

[v-evelk]

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