If you want to keep track of what is happening on Office 365 and what updates are rolling out and coming down the line check this site:
http://office.microsoft.com/en-us/products/office-365-roadmap-FX104343353.aspx
Trust me, a lot is happening on Office 365!
If you ever used Power Pivot to calculate things such as sales amount per capita or averages of some sort you will have run into the situation that the denominator (the column you want to divide by) is empty or zero. To cope with a potential division by zero, Power Pivot outputs Infinity. This can be seen in the screenshot below where the ‘Per Capita’ column is defined as:
|
1 |
=[SalesAmount]/[Numer of citizens] |
Of course you can fix this by using
|
1 |
IF(ISBLANK([InputColumn])) |
and others to work around the error. However, the DIVIDE() function makes this all a lot easier!
The DIVIDE() function takes two required and one optional parameters, which are: numerator, denominator and an optional value to return when division by zero occurs.
To see what DIVIDE() does, consider the following screenshot:
The Divide1 column here is defined as:
|
1 |
=DIVIDE([SalesAmount];[Number of citizens]) |
Whereas the Divide2 column contains the following function:
|
1 |
=DIVIDE([SalesAmount];[Number of citizens];0) |
The results are great, no Infinities are returned! By default DIVIDE() returns empty in case of a problem (Divide1 column). You can override this by specifying the third parameter so to return a fixed value in cased of a problem (Divide2 column in my example).
Hope this helps!
Today we (re)launched SkyDrive OneDrive, our solution for storing, sharing and editing documents in the cloud. OneDrive is cross platform (Android, iOS, Windows Phone, Windows) and syncs files automatically. It even enables you to edit Office files right there in the browser. Even better: it’s free!
Check it out: http://blog.onedrive.com/onedrive-for-everything-your-life/
In this post we will have a look at how to install, setup and register a Data Management Gateway for Power BI. It involves installing software on a server which will function as the gateway as well as configuration through the Power BI Admin Center. Once set up you can use the gateway to publish on-premises sources for use through Power BI.
That’s it! You have now successfully installed and registered a Data Magement Gateway for Power BI. Next up is creating sources. I’ll discuss in a future post how to create an OData feed through the Power BI Admin Center.
I was hired as FTE at Microsoft in November 2008 so recently celebrated five years at Microsoft! Still going strong and enjoying every day J
Below is the glass award I received:
Just a quick post: I will be speaking at SharePoint Connections Amsterdam 2013 (19th-20th November 2013) on Power BI for Office 365.
More info on: www.nccomms.com/sharepoint_connections.
I can get you a 10% discount, just reach out to me.
I recently picked up my new laptop, which of course runs Office 2013 and Windows 8.
When you try to install the Master Data Services add-in for SQL 2012 you may run into a warning that says you need Office 2010.
There is an easy fix: just install the Master Data Services add-in for SQL 2012 SP1 (get it here: http://www.microsoft.com/en-us/download/details.aspx?id=35581 . Be sure to pick 32 / 64 bit to match your Office version.
Oh and of course you will have to get the other pre-req as well: Visual Studio 2010 Tools for Office runtime (find it here: http://www.microsoft.com/en-my/download/details.aspx?id=35594).
See http://support.microsoft.com/kb/2774422 for more information.