Forum Discussion

RaedHussein's avatar
RaedHussein
New Member
5 years ago
Solved

Count item names

Hey everyone I Have a selling table that every time I sell an item it updated new row with the item name and selling price and some other columns, I want make a new table that contains 2 columns o...
  • _adamdosso's avatar
    5 years ago

    IN DAX, create a new table 

     

    NEW_TABLE = SUMMARIZE(TABLE_NAME,
                                                 ITEM_COLUMN_NAME,
                                                 "UNITS_SOLD", COUNTROWS(TABLE_NAME)
                                                  )
     
    You can do it with Power Query too