Selected Tags:

dax

Available Tags: calculate, cheat-sheet, connection, cube formula, cube forumals, data mining, date, demo, example, excel, excle, faq, format, introduction, load, many-to-many, must read, performance, relationship, setup, sharepoint, ssrs, time, video
Title Author Date
SQL Server 2008R2 Self Service BI - Gemini (PowerPivot) - how it performs with bigger tables Vidas Matelis 08/19/2009
Introduction to Data Analysis Expressions (DAX) in Gemini (PowerPivot) Howie Dickerman 10/01/2009
PowerPivot DAX function list with samples Vidas Matelis 10/08/2009
Trying to solve a business problem with Powerpivot, Gemini CTP2 Kasper de Jonge 10/26/2009
Announcing the Great Football Project (PowerPivot) Rob Collie 10/27/2009
My tweets from SQL PASS Summit 2009 - SSAS, PowerPivot, DAX and more Vidas Matelis 11/09/2009
DAX: The =RELATED() Function Rob Collie 11/10/2009
List of PowerPivot DAX functions with description Vidas Matelis 11/13/2009
List of PowerPivot DAX functions (short) Vidas Matelis 11/13/2009
Introducing PowerPivot DAX Measures Rob Collie 11/16/2009
Understanding DAX - Context (Row) Shaun Ryan 11/28/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
First steps in DAX: Year-To-Date Chris Webb 12/01/2009
Calculated Columns in PowerPivot Robert C. Cain 12/04/2009
DAX: Running Totals Chris Webb 12/05/2009
Getting difference of two dates in seconds with PowerPivot DAX Kasper de Jonge 12/05/2009
Q: How can I calculate difference between two dates in DAX (seconds, minutes, hours, days and months) Vidas Matelis 12/05/2009
Lookups in PowerPivot Calculated Columns - Using the RELATED Function Robert C. Cain 12/07/2009
Many-to-Many relationships in PowerPivot Marco Russo 12/07/2009
Putting the "Intelligence" in "Business Intelligence" Rob Collie 12/07/2009
DAX's CALCULATE() function - Pivots will never be the same Rob Collie 12/09/2009
PowerPivot DAX: CALCULATE is a supercharged SUMIF Rob Collie 12/15/2009
Step by Step guide for creating demo PowerPivot workbook from AdventureWorksDW SQL tables Vidas Matelis 12/17/2009
DAX CALCULATE, and Rapid Iteration Rob Collie 12/17/2009
How to add DAX calculations to the PowerPivot workbooks Vidas Matelis 12/18/2009
Distinct Count Measure in PowerPivot using DAX Marco Russo 12/26/2009
Solving a business problem with Powerpivot CTP3 using DAX Timefunctions Kasper de Jonge 12/31/2009
Creating a SSRS report on a published SharePoint PowerPivot app Kasper de Jonge 12/31/2009
How CALCULATE works in DAX Marco Russo 01/03/2010
Touchdown Problem Solved, and COUNTROWS Rob Collie 01/09/2010
Solving the 'Events in Progress' Problem in DAX, Part Two: Aggregating Dates and Multiselect Chris Webb 01/13/2010
ABC Analysis in PowerPivot Marco Russo 01/19/2010
PowerPivot, DAX and Semi-additive measures Russell Christopher 01/21/2010
Powerpivot - Installation, first report, dax Yaniv Mor 01/25/2010
Create a #PowerPivot report filtered by the Top X Users by "Logic" Denny Lee 01/28/2010
Pivots, I have not forgotten ye! Rob Collie 02/05/2010
Pivots, Cube Formulas, Named Sets … Oh my! Denny Lee 02/05/2010
Avoiding calculated column in DAX Marco Russo 02/06/2010
How to relate tables in DAX without using relationships Marco Russo 02/09/2010
Using Time intelligent PowerPivot functions with fiscal year Kasper de Jonge 02/09/2010
Jewelry Mashup for Alpha Geek Challenge Bill Jelen 02/11/2010
Rob Collie PowerPivot video (from Swedish UG meeting) Rob Collie 02/11/2010
Screencast: Using datamining with PowerPivot in Excel Kasper de Jonge 02/13/2010
SUMX() – The 5-point palm, exploding fxn technique Rob Collie 02/24/2010
When is null not a null? Dave Wickert 02/24/2010
Revisiting ALL() Rob Collie 02/25/2010
Video - Microsoft BI PowerPivot DAX Time calculations : YTD Nico Verbaenen 02/26/2010
Writing a RANK measure (and living to tell the tale) Rob Collie 03/10/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