## Excel : list of installed base

QUESTION : Thanks in advance for helping me out! How would you advise me to go from this table: Equipment […]

## Excel function/Date Table – Defining week and period

QUESTION : Forgive me if this is a rookie question, however I’m kind of at a loss. I’ve been evaluating […]

## Excel: Add 3rd “values” column to show percentage of one column against another

QUESTION : Please see attached – how would I get another column in to show the 3rd column as a […]

## How can I publish excel workbook with data populated using PowerQuery to SharePoint or website and have the data refresh on the site?

QUESTION : I have an Excel Workbook that gets data from an API using PowerQuery, to populate the tables. There […]

## many to many in excel power pivot

QUESTION : I understand that working with many to many table structures in power pivots could be complex: http://sqlblog.com/blogs/marco_russo/archive/2009/12/07/many-to-many-relationships-in-powerpivot.aspx?CommentPosted=true#commentmessage http://sqlblog.com/blogs/alberto_ferrari/archive/2010/10/19/powerpivot-and-many-to-many-relationships.aspx?CommentPosted=true#commentmessage […]

## Excel PowerPivot – Working out percentages for columns in a PowerPivot

QUESTION : For illustration, I have two columns: Col1 | Col2 ———— A | Y A | Y A | […]

## How to convert and Excel formula to a PowerPivot formula?

QUESTION : I need to convert this Excel sheet formula to an PowerPivot formula: =IF(D3=0,”NA”,B3/D3) B3 = F5 D3 = […]

## Difference between two averages in excel power pivot

QUESTION : I have the following data table in excel, showing how many apples i collected in the first 12 […]

## Combine data from two seperate tables in Power Pivot without using a join based on concatenated key

QUESTION : I have two separate data sources with effectively the same columns Date Vendor Campaign Ad group Keyword Impressions […]

## How to make a DAX measure NOT to re-calculate on aggregated levels?

QUESTION : I have a DAX measure which works perfectly on the level 0 POV in the Pivot Table but […]

• 1
• 2