Forum Discussion

LCook's avatar
LCook
Frequent Visitor
2 years ago
Solved

Summarize in Power BI

I've tried multiple formulas but cannot get my data to summarize. Example of the data is:   Date Location Unit Type Outbound Units 11/9 Miami Small 500 11/9 Chicago Large 625 1...
Need Help
  • Dangar332's avatar
    Dangar332
    2 years ago

    Hi, LCook 

    Table 2 = 
ADDCOLUMNS(
       SUMMARIZE('Table (4)','Table (4)'[Date],'Table (4)'[Location]),
       "total unit",
        CALCULATE(SUM('Table (4)'[Outbound Units]))
          )


    try below

     

LCook's avatar
LCook
Frequent Visitor
2 years ago

Thank you! This worked! I think I know where I was originally going wrong now.