Selected Tags:

faq
Available Tags: data refresh, date, dax, excel, format, internals, management, setup, sharepoint
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