Search found 7 matches

by Nerdio
Fri Sep 17, 2021 5:14 pm
Forum: PowerPivot/DAX
Topic: Ranking a column in one table against related occurrences [Solved]
Replies: 2
Views: 457

Re: Ranking a column in one table against related occurrences [Solved]

I have a solution.

NumOrders:=DISTINCTCOUNT(Orders[Order Num])

then

ItemRank:=IF([NumOrders]>0,RANKX(ALLSELECTED(Items[SKU]),[NumOrders]),BLANK())
by Nerdio
Wed Sep 15, 2021 6:51 pm
Forum: PowerPivot/DAX
Topic: Ranking a column in one table against related occurrences [Solved]
Replies: 2
Views: 457

Ranking a column in one table against related occurrences [Solved]

I have two tables, one which is a list of SKUs, the other is a list of orders for those SKUs. Something like this. SKU | Description S001 | Item #1 S002 | Item #2 S003 | Item #3 Order No. | SKU | Quantity O0001 | S001 | 2 O0002 | S001 | 3 O0002 | S003 | 1 O0003 | S002 | 5 O0004 | S001 | 2 O0004 | S0...
by Nerdio
Thu Jun 17, 2021 8:13 pm
Forum: PowerPivot/DAX
Topic: Reference a table variable in SUMX
Replies: 1
Views: 307

Reference a table variable in SUMX

I have written following DAX code for a measure VAR ItemTable = SUMMARIZE(Merge1, Merge1[Item Code], "Occurences", DISTINCTCOUNT(Merge1[Order Id])) VAR Result = SUMX(ItemTable, ItemTable[Occurences]) RETURN Result ItemTable gives me a simple table of Item Codes and a numeric column called ...
by Nerdio
Wed Jun 16, 2021 6:12 pm
Forum: PowerPivot/DAX
Topic: Creating data for a Pareto Chart
Replies: 0
Views: 211

Creating data for a Pareto Chart

I have seen a number of articles and videos online about using DAX in Power Pivot to create a data set for a Pareto Chart. None of them quite fit my scenario though. Being still reasonably inexperienced with DAX I have not been able to adapt what I have seen to give me what I want. I have a data tab...
by Nerdio
Mon May 17, 2021 9:32 pm
Forum: PowerPivot/DAX
Topic: Create an 'empty' or template data model [Solved]
Replies: 2
Views: 1219

Re: Create an 'empty' or template data model [Solved]

Thanks for the reply. I have tried this, and it looks to be quite straight-forward. I did a simple test by using Power Query to load a table from one file, then used Power Query to load another identical table (different data). The original table was overwritten. I just had to change the data source...
by Nerdio
Thu May 13, 2021 8:58 pm
Forum: PowerPivot/DAX
Topic: Create an 'empty' or template data model [Solved]
Replies: 2
Views: 1219

Create an 'empty' or template data model [Solved]

I think this may fall under Power Query for a solution, so apologies if this is the wrong place to post the question. We collect data from our customers in conventional spreadsheets. These tend to be very large, 10's of MB each. I have found that by importing the data into an Excel Data Model (in a ...

Go to advanced search

cron