Selected Tags:

faq
Available Tags: admin, data refresh, date, dax, excel, format, gallery, internals, management, problem, setup, sharepoint, tip
Title Author Date
How to install PowerPivot for Excel and list of know issues Vidas Matelis 11/21/2009
Q: How can I check what version of PowerPivot for Excel is installed on my machine? Vidas Matelis 11/25/2009
Q: How can I delete PowerPivot report published into SharePoint PowerPivot gallery? Vidas Matelis 11/26/2009
Q: How can I see Analysis Services database structure that is stored within PowerPivot ? Vidas Matelis 11/27/2009
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? Vidas Matelis 11/29/2009
Q: Where in SharePoint can I define "Business Hours" for PowerPivot data refresh? Vidas Matelis 12/01/2009
Q: How can I calculate difference between two dates in DAX (seconds, minutes, hours, days and months) Vidas Matelis 12/05/2009
How to add DAX calculations to the PowerPivot workbooks Vidas Matelis 12/18/2009
Q: Where PowerPivot for SharePoint logs are located and how to read them? Vidas Matelis 01/05/2010
Q: How can I change maximum PowerPIvot file size that can be uploaded to SharePoint 2010? Vidas Matelis 01/05/2010
Q: How do I hide "Grand Total" calculation for PowerPivot columns and/or rows? Vidas Matelis 01/05/2010
Q: How can I create Calendar Date/Time table for PowerPivot if I do not have any source for that? Vidas Matelis 01/09/2010
Q: How can I create Fiscal Date/Time table for PowerPivot if I do not have any source for that? Vidas Matelis 01/12/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? Vidas Matelis 03/10/2010
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? Vidas Matelis 03/17/2010
SharePoint 2010 and PowerPivot Q & A by Shared Squared ShareSquared.com 03/18/2010
Q: How can I change connection information (server name, DB name, etc) for existing PowerPivot table? Vidas Matelis 03/24/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? Vidas Matelis 03/24/2010
Q: How can I find how much space each table uses in PowerPivot? Vidas Matelis 04/28/2010
Q: How can I see what internal commands PowerPivot executes in its engine? Vidas Matelis 05/09/2010
 

Varigence Vivid