measue

  1. S

    How to Calculate Across multiple tables Power Pivot / Calculated Field?

    Hi All! I'm a bit new to this, so any help would be highly appreciated! I have a Few Tables, Mainly the "Highlighted below" are my 2 (soon to be 3) primary data tables, Harvest TIME has "time" expenses, Harvest Expense the "Software" Expenses (and dates of the expenses), and later i will be...
    • SioSho
    • Thread
    • calculaing field excel measue power pivot
    • Replies: 1
    • Forum: Power Tools
  2. S

    Should I prefilter my sql server statement or have power query

    I'm looking to speed up my Excel file with lots of data being pulled from our sql server system. I've created statements like below and would like to know if I should pre filter the sales from 2015 and prior. Rather than having power query remove the unneeded rows and columns. If so how would...
  3. G

    Using distinct twice in one measure

    Hi, I have a measure in powerpivot: Mix % Measure Avg:=averagex(DISTINCT(Forecast[Product]),Forecast[Mix %Measure])/100 I need to use another distinct measure in this for a column called (Forecast[Submission]). This would mean the measure takes the average of each individual product as it...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top