PowerPivot Excel 2016 Dax/Measure for Top 50 items

Anything related to PowerPivot and DAX Formuale
ajibios@hotmail.com
Posts: 2
Joined: Thu Sep 20, 2018 2:32 pm

PowerPivot Excel 2016 Dax/Measure for Top 50 items

Postby ajibios@hotmail.com » Thu Sep 20, 2018 2:37 pm

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)

Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 3 guests