excel

Display # 5 10 15 20 25 30 50 100 All

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: I have integer amount that represents duration in seconds. How can show this amount in format "h:mm:ss"?

Written by Vidas Matelis on 26 October 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.

QlikView from a PowerPivot standpoint

Written by Donald Farmer on 30 January 2010.

Quantum shifts with PowerPivot

Written by Ken Puls on 07 October 2010.

Querying PowerPivot DMVs from Excel

Written by Chris Webb on 27 February 2011.

Ranking within Slicer Selection in Power Pivot

Written by Jason Thomas on 22 May 2014.

Reading your #PowerPivot Profiler trace

Written by Denny Lee on 30 January 2010.

Recorded webcast - A Preview to PowerPivot Server Best Practices

Written by Microsoft on 17 December 2009.

Recorded webcast: "Introduction to PowerPivot or How I Learned to Stop Worrying and Love Excel"

Written by Chris Webb on 13 December 2009.

Refreshing Excel workbooks with embedded PowerPivot models from SharePoint Online

Written by Microsoft on 05 March 2013.

Refreshing PowerPivot Data

Written by Robert C. Cain on 10 December 2009.

Returning Selected Items in an Excel Slicer Using MDX in PowerPivot and SSAS

Written by Chris Webb on 22 October 2012.

• 17
• 18
• 19
• 20
• 21
• 22
• 23