DAX

A few years ago I wrote this post on how to alias columns in a table in DAX, using a combination of AddColumns() and Summarize(). The good news is that in Excel 2016/the Power BI Designer/SSAS Tabular…

Total Margin for Power BI in Sales_opps_wonTotal Margin = IF([ProdType]= "product" , [qty]*[margin], [Margin])Total Margin for SSMS in Sales_opps_wonsum(CASE WHEN [ProdType] = 'Product' t...

Get with Jason on Active Partners/Active MarginSO_OppoturnityCW: 0F68B2LT: 348C35 or 50B848QL: 775EA6 or 836AB8LicenseValue - in Instance, grouping of Licensce or Package, CustCol...

Tabular Models, Multiple Data Sources and Unknown Members via Instapaper https://sqlserverbiblog.wordpress.com/2015/12/28/tabular-models-multiple-data-sources-and-unknown-members/

New SQL Server 2014 CU11 and SP1 CU4 Available for Download via Instapaper http://sqlserverupdates.com/news/new-sql-server-2014-cu11-and-sp1-cu4-available-for-download/

An advantage of DAX measures over calculated columns is that they respond to user interaction.  As such, you may be inclined to allocate all calculation logic into measures when there is a nee…

If you’ve read my blog for a while you may have seen the following posts: Ten MDX Calculations For Your Cube (part 1) Ten MDX Calculations For Your Cube (part 2) Well the time has come for me to pu…

Information, tips, news and announcements about Azure Analysis Services (Azure AS) and SQL Server Analysis Services (SSAS) directly from the product team.

16 Feb 2015 1:08 PM This week I'm working to create a measure to count the total commits in a repository. I thought it was working until I looked at the grand total and found something was off.

Time intelligence functions are an advanced feature of DAX. They are typically composite functions built on top of other more basic DAX features and have more stringent requirements for the structure

Written by Vidas Matelis on 05 December 2009. User Rating:

I recently wrote an article on SQLBI about the semi-additive measures in DAX. I included the formulas common calculations and there is an interesting point that worth a longer digression: the

Values such as inventory and balance account, usually calculated from a snapshot table, require the use of semi-additive measures. In Multidimensional you have specific aggregation types, like

Keep rows that begin with alphabetical characters http://www.excelguru.ca/blog/2016/01/14/keep-rows-that-begin-with-alphabetical-characters/

Use Time intelligence functions to do a running sum of the last 6 months with PowerPivot - PowerPivotPro via Instapaper http://www.powerpivotpro.com/2010/07/use-time-intelligence-functions-to-do-a-running-sum-of-the-last-6-months-with-powerpivot/

Kasper de Jonge PowerPivot and Power BI Blog | Get the YTD of same period last year using DAX via Instapaper http://www.powerpivotblog.nl/get-the-ytd-of-same-period-last-year-using-dax/

How about a FIRSTDATE()? - PowerPivotPro via Instapaper http://www.powerpivotpro.com/2014/10/how-about-a-firstdate/

Have You Ever Seen This Cryptic Error?

The Greatest Formula in the World, Part 3 - PowerPivotPro via Instapaper http://www.powerpivotpro.com/2011/12/the-greatest-formula-in-the-world-part-3/

Power BI Desktop, Sort By Column And DAX Calculations That Use The All() Function via Instapaper http://blog.crossjoin.co.uk/2015/12/15/power-bi-desktop-sort-by-column-and-dax-calculations-that-use-the-all-function/

Precedence Part 3: ALLEXCEPT vs. ALL w/ VALUES - PowerPivotPro via Instapaper http://www.powerpivotpro.com/2011/06/precedence-part-3-allexcept-vs-all-w-values/

Detecting ALL() - Detecting When Not Filtered - PowerPivotPro via Instapaper http://www.powerpivotpro.com/2011/09/detecting-all-detecting-when-not-filtered/

Paper or Plastic:  Measure, or Calc Column? “What?  I’ve Never Written This Post?”  “No???

Portable formulas: A PowerPivot benefit you won't believe you lived without, part 2 - Office Blogs via Instapaper https://blogs.office.com/2011/05/26/portable-formulas-a-powerpivot-benefit-you-wont-believe-you-lived-without-part-2/

Organizing Your Measures With a “Dummy” Table – Guest Post From Eric Hutton - PowerPivotPro via Instapaper http://www.powerpivotpro.com/2013/02/organizing-your-measures-with-a-dummy-table-guest-post-from-eric-hutton/

Rip van Winkle wakes up and looks around I have a confession to make:  when it comes to technology, I’m a much better writer than reader.  I don’t pay near

Why PowerPivot is Better Fed from a Database, Pt2 - PowerPivotPro via Instapaper http://www.powerpivotpro.com/2011/11/why-powerpivot-is-better-fed-from-a-database-pt2/

Quick Tip: Don’t Over-Use FILTER() - PowerPivotPro via Instapaper http://www.powerpivotpro.com/2010/04/quick-tip-dont-over-use-filter/

The Superheroes of DAX, and derived measures - PowerPivotPro via Instapaper http://www.powerpivotpro.com/2010/02/the-superheroes-of-dax-and-derived-measures/