faq

Display # 5 10 15 20 25 30 50 100 All

How to add DAX calculations to the PowerPivot workbooks

Written by Vidas Matelis on 18 December 2009.

How to install PowerPivot for Excel and list of know issues

Written by Vidas Matelis on 21 November 2009.

Q: How can I calculate difference between two dates in DAX (seconds, minutes, hours, days and months)

Written by Vidas Matelis on 05 December 2009.

Q: How can I change connection information (server name, DB name, etc) for existing PowerPivot table?

Written by Vidas Matelis on 24 March 2010.

Q: How can I change maximum PowerPIvot file size that can be uploaded to SharePoint 2010?

Written by Vidas Matelis on 05 January 2010.

Q: How can I check what version of PowerPivot for Excel is installed on my machine?

Written by Vidas Matelis on 25 November 2009.

Q: How can I create Calendar Date/Time table for PowerPivot if I do not have any source for that?

Written by Vidas Matelis on 09 January 2010.

Q: How can I create Fiscal Date/Time table for PowerPivot if I do not have any source for that?

Written by Vidas Matelis on 12 January 2010.

Q: How can I delete PowerPivot report published into SharePoint PowerPivot gallery?

Written by Vidas Matelis on 26 November 2009.

Q: How can I find how much space each table uses in PowerPivot?

Written by Vidas Matelis on 28 April 2010.

Q: How can I see Analysis Services database structure that is stored within PowerPivot ?

Written by Vidas Matelis on 27 November 2009.

Q: How can I see what internal commands PowerPivot executes in its engine?

Written by Vidas Matelis on 09 May 2010.

Q: How do I hide "Grand Total" calculation for PowerPivot columns and/or rows?

Written by Vidas Matelis on 05 January 2010.

Q: I have a field in the pivot that shows duration on some event in seconds. How can I create calculated measure using DAX that would convert numeric result (seconds) to string in the format hh:mm:ss?

Written by Vidas Matelis on 10 March 2010.

Q: In my source data I have daily balance values. How in PowerPivot for Excel can I create calculation that shows correct closing balance for year, quarter and month?

Written by Vidas Matelis on 29 November 2009.

Q: My DAX formula in the PowePivot returns error message: "The value for columns "ColumnName1" in table "Table1" cannot be determined in the current context. How can I fix this?

Written by Vidas Matelis on 17 March 2010.

Q: My PowerPivot table was loaded from the SQL Server table that recently was changed. How can I apply these source table changes to PowerPivot table?

Written by Vidas Matelis on 24 March 2010.

Q: Where in SharePoint can I define "Business Hours" for PowerPivot data refresh?

Written by Vidas Matelis on 01 December 2009.

Q: Where PowerPivot for SharePoint logs are located and how to read them?

Written by Vidas Matelis on 05 January 2010.

SharePoint 2010 and PowerPivot Q & A by Shared Squared

Written by ShareSquared.com on 18 March 2010.