Make Your Numeric Division Faultless in Power Query

When you work with data it is normal that you apply numeric calculations. Numeric calculations in Power Query depends on the nature of data returns different results. One of the most error prone calculations is division. Power Query behave differently when you divide a number by zero, zero by zero, number by null, and non-numeric ...

Read More

Power Query Library of Functions; Shared Keyword

As I mentioned earlier in Power BI online book, Power Query is a functional language. Knowing functions is your best helper when you work with a functional language. Fortunately Power Query both in Excel and Power BI can use shared keyword to reveal a document library of all functions. I’ve written about shared keyword almost ...

Read More

Interactive R Charts in Power BI

Posted by on Jun 9, 2016 in Power BI, R | 2 Comments

In previous videos you’ve learned that we can demonstrate R visualization in Power BI, In this video you will learn how R visualization is working interactively with other elements in Power BI report. In fact Power BI works with R charts as a regular visualization and highlighting and selecting items in other elements of report ...

Read More

Power BI Desktop May 2016 Update; Quick Check

Posted by on Jun 1, 2016 in Power BI | No Comments

Power BI Desktop May 2016 Update is out now, and there is still no official announcement in Power BI blog for it, however Koen already posted a blog post about it. Just to name a few major updates; Conditional Formatting, Quick Calc, and Three new standard measures. Here are my first glance view of these ...

Read More