DAX Relationships
Learn how relationships work in Powerpivot workbooks and how you can build them using the DAX language.
2014-05-29
3,137 reads
DAX
Percentile calculations in DAX
It is not always easy to do what Excel does with PERCENTILE.INC. Learn what formulas to use in this article.
2014-04-28
4,107 reads
DAX Statistical Functions
Following on from his first four articles on using Data Analysis Expressions (DAX) with tabular databases, Robert Sheldon dives into some of the DAX statistical functions available, demonstrating which are the most useful and examples of how they work.
2013-10-07
2,818 reads
Using DAX to create SSRS reports: The Basics
You can use DAX to create reports from a tabular database in SQL Server Reporting Services. To do so requires a few workarounds. Rob Sheldon describes a poorly-documented but important technique for Business Intelligence.
2013-09-09
4,222 reads
Using DAX to retrieve tabular data
Data Analysis Expressions (DAX), originally the formula language for PowerPivot workbooks, can also be used within the MDX query window of SSMS to directly access data from a tabular SSAS database, an in-memory database that uses the xVelocity analytics engine and compression. Robert Sheldon shows how easy it is to retrieve data from a tabular database.
2013-07-15
3,237 reads
DAX Query - Part 2
A more detailed look at the DAX language and some of its more frequently used functions
2013-12-13 (first published: 2013-05-02)
11,594 reads
DAX Query Basics
In this document I will attempt to talk you through writing your first very simple DAX queries. For the purpose of this document I will query the rather familiar Adventure Works Tabular Cube.
2013-12-12 (first published: 2012-09-25)
30,399 reads
Blogs
Do This Before You Contact Your SQL Server Consultant
Say you need outside help. You’ve exhausted all the things that you could do...
Microsoft MVP 2026: Ten Years on the Data Platform
I’m honored to announce that I’ve been renewed as a Microsoft MVP for the...
Building AgentDBA’s Slack Escalation
By Arun Sirpal
Until now, a CRITICAL finding did the right internal routing, but the last mile...
Forums
ALAMAT KONTAK BCA KCP Citraland Telp:08218154393
WA:08218154393 Citraland, Gateway Junction, Jl. Ruko No.1&2 Blok TL06, Lidah Kulon, Kec. Lakarsantri, Surabaya,...
ALAMAT KONTAK BCA KCP Prapen Telp:08218154393
WA:08218154393 Jl. Raya Prapen No.38, Sidosermo, Kec. Wonocolo, Surabaya, Jawa Timur 60299
Developer edition cannot be connected from other computers
I installed a new SQL server 2025 Enterprise developer edition for our development environment....
Question of the Day
Moving the Error Log
How can I change the location in which the SQL Server error log is written in SQL Server 2025?
See possible answers