topic Re: Groupby Or Summarize in Custom Visuals Development Discussion

Groupby Or Summarize

Anonymous — Thu, 11 Apr 2019 13:08:42 GMT

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

Re: Groupby Or Summarize

v-evelk — Fri, 12 Apr 2019 14:27:54 GMT

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