dax

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/

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

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

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/

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/

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/

Have You Ever Seen This Cryptic Error?

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

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/

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/

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

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

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

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

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

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.

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

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…

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…

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/

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/

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

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...

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…

This measure allows you to predict dependent values Y from independent values X. NAME: Simple linear regression DESCRIPTION: Estimate Y values based on X values. PARAMETERS: Name: Category Tooltip: Th…

This article introduces a technique to filter and productively compare two time periods with Power BI. Time intelligence calculations are among the most re

Level: Intermediate Background I was reading the questions at http://community.powerbi.com today and saw an interesting question. In short the OP wanted to know if there was a way to identify (via a m…

Despite all articles, blog posts, and videos on the topic of DAX Measures and Calculated columns, I still hear here and there that people ask what is the difference between Measure and Calculated Colu…

I first learnt about the new DAX UNICHAR function in Power BI by reading Chris Webb’s blog (which was also the inspiration for this article today). One of the uses of the UNICHAR function is to be abl…