Search found 52 matches

by Steve_D
Thu Dec 15, 2016 9:23 am
Forum: PowerPivot/DAX
Topic: Aggregating Store Count Measure
Replies: 11
Views: 1338

Aggregating Store Count Measure

This is doing my head in. I have tried everything I can think of to solve this problem and but the standard methods aren't working. I have a file of data which shows products sold in key accounts for each of the states of Australia by week for the last three years (standard FMCG scan data file). The...
by Steve_D
Wed Dec 14, 2016 1:13 pm
Forum: PowerPivot/DAX
Topic: Move/Split Power Pivot Model
Replies: 2
Views: 558

Re: Move/Split Power Pivot Model

Thanks Matt. Saving the GL as a table was the only course of action available.
by Steve_D
Fri Dec 09, 2016 9:22 am
Forum: PowerPivot/DAX
Topic: Move/Split Power Pivot Model
Replies: 2
Views: 558

Move/Split Power Pivot Model

I've gotten to a stage where the model I've created is constantly blowing the available memory (yes, it's 32 bit Excel and no, 64 bit is not an option). The model uses two Power Queries which draw in Budget sales data, which is then referenced by the second query to create a GL level view of the Sal...
by Steve_D
Tue Nov 29, 2016 3:19 pm
Forum: PowerPivot/DAX
Topic: Using Text from a Harvester table
Replies: 2
Views: 473

Re: Using Text from a Harvester table

Yep, worked!
by Steve_D
Tue Nov 29, 2016 12:32 pm
Forum: PowerPivot/DAX
Topic: Using Text from a Harvester table
Replies: 2
Views: 473

Using Text from a Harvester table

I've created a harvester table which has text as the harvest element. Everything I've read so far shows the harvester variable as value which you apply a min, max calculation to reduce it to a scalar value. How do you achieve the same result with text?
by Steve_D
Wed Nov 16, 2016 12:26 pm
Forum: Power BI Desktop/Service
Topic: Custom Visualisations Disappeared
Replies: 3
Views: 959

Re: Custom Visualisations Disappeared

You may find that you need to obtain an update of the Custom visualisation after the October release.
by Steve_D
Wed Nov 16, 2016 12:22 pm
Forum: Power Query
Topic: Extract a Column from a data set
Replies: 4
Views: 617

Re: Extract a Column from a data set

Thank you, much appreciated.
by Steve_D
Fri Nov 11, 2016 8:26 am
Forum: Power Query
Topic: Extract a Column from a data set
Replies: 4
Views: 617

Extract a Column from a data set

I currently import a data set which is over 100Mb in size. That in itself is not a problem but, I then further shape the data by referencing the data table 6 times and perform a series of grouping methods to create different views of the data ie. Group the data by state, Group the data by Customer G...
by Steve_D
Thu Nov 10, 2016 12:32 pm
Forum: Excel
Topic: How do I get Excel to be more like a database
Replies: 7
Views: 1316

Re: How do I get Excel to be more like a database

Yeh/No, the post audit is good and helps identify incorrectly aligned indexes but, I'd rather avoid the issue altogether by having the data table insert an index item from the a source (possibly the master table). Not only would this reduce the number of translation errors but help with new products...
by Steve_D
Tue Nov 01, 2016 12:54 pm
Forum: Excel
Topic: How do I get Excel to be more like a database
Replies: 7
Views: 1316

Re: How do I get Excel to be more like a database

Matt, Attached is an example of what I was trying to explain. The naming convention is straight forward. 1. The Master Table contains a list of Items which has associated attributes used to convert Forecast volumes to Reporting Qty as well as a Product categorisation hierarchy. 2. The Slave Table co...

Go to advanced search