I have created below model. Sales-data containes 600K rows, Dcalender 750 rows, Item info 1700 rows, Customer info 2000 rows, and remaining dimension tables app 25 rows.
2 calculated columns in DCalender, all other calculations have been created with DAX measures or M language custom columns.
I'd like to get the best possible freeware virtual machine (VM) for Excel 2010 or 2013. 1st criterion is performance, 2nd criterion is overall usability. I've done a little research and tried VMware Workstation 16 and Oracle VM VirtualBox.
VMware beats Oracle on my machine in terms of...
I'm having some performance issues with Sumx that are causing very slow measure performance as was wondering if you smart people would know of a better way to accomplish these
'Take the slicer selection date'
VAR CalculationDate= [SelectedDate]
'Calculate USD values...
I would like to use Defined Names more prevalently in my Excel files.
This comment directly below taken from decisionmodels.com has given me pause for thought.
"Defined Names are recalculated each time a formula that directly refers to the name is recalculated"
To be honest I don't quite...
I tried this snippet in Excel/Power Query to find empty and constant columns in my table:
Table.Column(previous_step, _))) <= 1),
However, when I use this with about 60...
My VBA code currently loops for 5,000 iterations and takes about 25 minutes to collect the output data in the Output excel sheet. Is there a way to reduce the time taken for instance by improving the copying and pasting of values, collecting the output data in some kind of array etc.? Given that...
Do you know of any software that analyses an Excel workbooks performance (i.e. calculation speed) and determines the bottlenecks, i.e. DataTables, slow formulas etc?
I have a file that takes 0.5s to recalculate but i need to recalculate ~10 times and rerun dozens of times so every...
OK, here it goes. I'm a helicopter pilot and in the operator's manual of the aircraft is a performance section. What I'm trying to do is take the performance charts and convert them to excel. basically its a scatter chart with different variables. In short you take the temperature match it up to...
I have recently discovered that SUMIFS only works between two different workbooks if both workbooks are open at the same time.
I've also read to get round this, SUMPRODUCT can be used. That said I can't get it working.
The SUMIFS version of the formula I need converting to SUMPRODUCT is...
I'm trying to calculate the impact three ever changing variables are having on our month on month performance. We have 10 buckets that are filled with applications and the scenario is:
The total number of applications changes month on month
The % of total applications that sit...
I'm conducting a performance comparison between various versions of Excel.
I'm looking for real world examples of slow or expensive to calculate sheets. If anyone knows of some examples they could share that would be great.
I have two sheets where I have the same colored cells that each have a number. On the first sheet I only want the numbers below 50 and in the other above 50.
I wrote a code for a command button to do so. The one code that deletes all the numbers above 50 takes about half a second...
How can I refer to a range rather than entire column?
Dim R As Long
R = Application.Caller.Row + 1
Do While Cells(R, "BN").Value <> "Yes"
If Cells(R, "BM") = "" Then Exit Do
Could you please offer some advice on following?
Our current accounts package sage 50, cannot calculate any on time delivery performance natively so I have to out reports to excel I have two worksheets in the same work book for monitoring supplier performance,
Sheet 1 “Supplier...
Could you please offer some advice on following?
Our current accounts package sage 50, cannot calculate any on time delivery performance natively so I have to out reports to excel I...
I am struggling to display data in a visual way. I am trying to show a customers market growth across several categories and then my companies growth in those categories relative to the market growth. As an example:
In Category 1, Customer A had growth of 2% in the market but our business...
I'm at a loss on this. I need to find the Overall +/- performance % of errors made over the 4 quarters of the year. I can get the performance +/- from the previous quarter but the overall is a mystery.
My data is:
1st 2nd 3rd 4th
50% 67% -55% -78%
Keep in mind that positive % =...
I am trying to create a tracking system for the data below. The macro will run in the first tab and track the data from the second tab. I need the macro to match the sections then look up the date from the first tab and determine which date range it falls into on the second tab. Once it has...
I am trying to automate a monthly investment commentary where I would write predetermined sentences in Word with certain portions of the sentences being left blank and meant to be linked to cells in an Excel worksheet; somewhat similarly to a mail merge greetings linked to an address book...