This is a collaborative blog post by  and  resulting from the forum discussion topic “Aggregating Duration/Time”. http://community.powerbi.com/t5/Desktop/Aggregating-Duration-Time/m-p/13350/highlight/true#M3358   Introduction Both Excel and DAX lack support for a true time duration data type makin...

“Excuse me, sir, you don't need 20 men, you need Miller Banfield.  He's an expert with explosives Excel, sir. He's probably the best in England

This DAX-VizArt-Wizard vizualizes dependencies between your DAX measures, shows the definition of all related measures and shows differences between the measures of 2 models/versions. This works for Power Pivot, Power BI (…) Read more

1. Column - WeekEnding = ((7-DayInWeek) + DateKey)2. Measure - Today = DATE(YEAR(NOW()), MONTH(NOW()), DAY(NOW()))3. Column - Last14Days = IF(AND(Calendar[WeekEnding]=Calendar[Today]-14, Calendar[WeekEnding]

A measure table is equivalent to a measure group in SSAS model for any other sources in Power BI Desktop. You can put all measures together in empty tables.

Information about Microsoft SQL Server Analysis Services (SSAS) 2005/2008 and MDX - News, Blogs, FAQs, Tools, Articles, Software, Books, Learnings, Webcasts, Scripts

This should work: =IF(IFERROR(SEARCH("Chrome",[SoftwareName]),-1)

I like to think I’m proficient at writing DAX and building SSAS tabular models. I enjoy a good challenge and appreciate requirements that cause me to stretch and learn. But sometimes I hit a …

I wrote an article about Time Intelligence in Power BI Desktop to explain how to fix measures using DAX functions for time intelligence when you have a data model where the relationship uses surrogate keys. THe short description is that all the time intelligence

PeriodCurrentMTDQTDYTDPY CurrentPY MTDPY QTDPY YTDYOYYOY%YOY YTDYOY% YTDPM CurrentMoMMoM%PQ CurrentQoQQoQ%

Introduction The case The purpose of the workbook is analyzing the daily sales in a month. I want to see the sales in the current month but also in the previous month. I have the following

Using PowerBI to simplify your SQL Server Migration Neil Hambly Neil Hambly is the practice lead for a UK Microsoft Data Platform Partner and regularly undertakes such migrations with his clients,

What if I told you, there was one key skill, that has set me head and shoulders above the Excel crowd when working with Power Pivot and Power BI? Would you

SQLBI is a blog dedicated to building Business Intelligence solutions with SQL Server. You can follow me on Twitter: @marcorus The latest version of Power Pivot Utils v 1.05 has a new feature that

by Matt Allington In this post, I am going to show you how simple it is to create a custom calendar using Power Query.  If you follow the steps below, you

In Power BI Desktop, we have the ability to create calculated

select MEASURE_NAME, EXPRESSION from $SYSTEM.MDSCHEMA_MEASURES

Introduction I'm not happy with the solution presented in my former post about Daily sales report  because the current month is determined...

Introduction A small blogpost about backing up your DAX Measures of PowerPivot in Excel 2013. Although PowerPivot is a great tool, it can ...

Introduction  In this blog post I would like show you step-by-step how to build a report in PowerPivot with DAX expressions. For my curren...

Hello, I have a quick question. I am trying to calculate the $ Change (YOY) for a sub category, and then trying to compare that overall sub category change to specific products. Basically, we want to find products that are underperforming a sub category, but by using dynamic comparison. Here is the ...