Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Groupby Or Summarize

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

Need Help

1 Reply

  • v-evelk's avatar
    v-evelk
    Microsoft Employee
    7 years ago

    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
    [email protected]