Thinking in DAX: Counting Products in the Current Status with PowerPivot

Posted by AlbertoFerrari on SQL Blog See other posts from SQL Blog or by AlbertoFerrari
Published on Tue, 08 Mar 2011 07:00:00 GMT Indexed on 2011/03/08 8:16 UTC
Read the original article Hit count: 272

Filed under:

PowerPivot

One of my readers came to me with an interesting formula to compute in PowerPivot. Even if I don’t normally post about very specific scenarios, I think this time it is interesting to write a blog post since the formula can be easily created, if you think at it in DAX, while it is very hard if you are still approaching it with an MDX or SQL mindset. Thinking in DAX is something that comes after a lot of formula authoring, something that all BI professionals should strive for, as Vertipaq in the new...(read more)

Related posts about PowerPivot

PowerPivot Workshop: new announcement and early bird expiring soon #ppws #PowerPivot

as seen on SQL Blog - Search for 'SQL Blog'
As always, I am a bit later than Marco in producing news. Nevertheless, I am very excited to tell you the new date for the Frankfurt workshop on PowerPivot: February 21-22, 2011 . Save the date and find all the relevant information on www.powerpivotworkshop.com , where you can also register… >>> More
Installing SharePoint 2010 and PowerPivot for SharePoint on Windows 7

as seen on SQL Blog - Search for 'SQL Blog'
Many people like me want (or need) to do their business intelligence development work on a laptop. As someone who frequently speaks at various events or teaches classes on all subjects related to the Microsoft business intelligence stack, I need a way to run multiple server products on my laptop with… >>> More
We are hiring (take a minute to read this, is not another BS talk ;) )

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
I really wanted to wait until our new website was out to blog about this but I hope you can put up with the ugly website for a few more days J. Tellago keeps growing and, after a quick break at the beginning of the year, we are back in hiring mode J. We are currently expanding our teams in the United… >>> More
Tellago is still hiring….

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
Tellago 's SOA practice is rapidly growing and we are still hiring. In that sense, we are looking to for Connected Systems (WCF, BizTalk, WF) experts who are passionate about building game changing solutions with the latest Microsoft technologies. You will be working alongside technology gurus like… >>> More
Back from Teched US

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
It's been a few weeks since I last blogged and, trust me, I am not happy about it :( I have been crazily busy with some of our projects at Tellago which you are going to hear more about in the upcoming weeks :) I was so busy that I didn't even have time to blog about my sessions at Teched US last… >>> More

Developer IT