Forum Discussion
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...
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
AlB Many thanks, this is my first time I used to ask, I won't next time >>
Yes Sure, but most of the cells is in the Arabic language except the header of columns
this is the link
https://www.dropbox.com/scl/fi/5mp76qw64ykninmxk3e2v/Birwaz-test-1-Copy.xlsx?dl=0&rlkey=8e9lamfhy7807ea1o5740opji
and this is a sample of what I am trying to do
The first visual on the left contains a number of selling the item and its revenue, the second one on the right calculates the profit depending on revenue - material cost.. it's work on the visual but not on the card, because the measure need corrections in filtering I guess so