Articles By Vidas Matelis

ArticleDate Published
DAX cheat sheet2010-Jun-17
Slicer impact on PowerPivot query performance2010-Jun-16
Changing how PowerPivot handles DAX errors2010-May-27
Q: How can I see what internal commands PowerPivot executes in its engine?2010-May-09
PowerShell Script - Calculate how much space each table uses in the PowerPivot workbook2010-May-07
Q: How can I find how much space each table uses in PowerPivot?2010-Apr-28
Learning PowerPivot for Excel and SharePoint administration2010-Apr-27
Learning PowerPivot and DAX2010-Apr-26
Guide for loading ContosoBI data into PowerPivot2010-Apr-25
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?2010-Mar-24
Q: How can I change connection information (server name, DB name, etc) for existing PowerPivot table?2010-Mar-24
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?2010-Mar-17
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?2010-Mar-10
Q: How can I create Fiscal Date/Time table for PowerPivot if I do not have any source for that?2010-Jan-12
Q: How can I create Calendar Date/Time table for PowerPivot if I do not have any source for that?2010-Jan-09
Q: How do I hide "Grand Total" calculation for PowerPivot columns and/or rows?2010-Jan-05
Q: How can I change maximum PowerPIvot file size that can be uploaded to SharePoint 2010?2010-Jan-05
Q: Where PowerPivot for SharePoint logs are located and how to read them?2010-Jan-05
How to add DAX calculations to the PowerPivot workbooks2009-Dec-18
Step by Step guide for creating demo PowerPivot workbook from AdventureWorksDW SQL tables2009-Dec-17
Q: How can I calculate difference between two dates in DAX (seconds, minutes, hours, days and months)2009-Dec-05
Q: Where in SharePoint can I define "Business Hours" for PowerPivot data refresh?2009-Dec-01
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?2009-Nov-29
Q: How can I see Analysis Services database structure that is stored within PowerPivot ?2009-Nov-27
Q: How can I delete PowerPivot report published into SharePoint PowerPivot gallery?2009-Nov-26
Q: How can I check what version of PowerPivot for Excel is installed on my machine?2009-Nov-25
How to install PowerPivot for Excel and list of know issues2009-Nov-21
Step by step guide on installing PowerPivot for SharePoint on a single machine2009-Nov-20
List of PowerPivot DAX functions (short)2009-Nov-13
List of PowerPivot DAX functions with description2009-Nov-13
List of suggested datasets to test PowerPivot2009-Nov-11
My tweets from SQL PASS Summit 2009 - SSAS, PowerPivot, DAX and more2009-Nov-09
PowerPivot DAX function list with samples2009-Oct-08
SQL Server 2008R2 Self Service BI - Gemini (PowerPivot) - how it performs with bigger tables2009-Aug-19