I need help to solve the following using Dax/Measure in PowerPivot Excel 2016..
1 – Top 50 grocery items spend…To identify grocery items, Grocery items have Product Code start with “X” and Category name start with four lower case letters. The table have 4 fields or columns namely: ITEMS, Product Code, Category Name, and AMOUNT. The ITEMS field contains grocery, electronics, and furniture while AMOUNT contains cost spend on each item e.tc.)
2- Top 100 items spend…( Note: I have a table with two fields/columns namely: ITEMS and AMOUNT. The ITEMS contains over 200 types like grocery, electronics, and furniture e.t.c while AMOUNT contains cost spend on each item)
Anything related to PowerPivot and DAX Formuale
1 post • Page 1 of 1
Who is online
Users browsing this forum: No registered users and 8 guests