Power BI

“THAT’s not a PivotTable!  Oh wait…” -Bill Gates (OK, so I turned it into a movie quote of sorts by using the picture of Anthony Michael Hall playing

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

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

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/

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

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/

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