Level: Intermediate Last week I attended the 2016 PASS Business Analytics Conference in San Jose. I attended my first BA Conference last year and had a blast – this year was equally as good. However I had a really interesting…
When you’re writing an M expression for a custom column in Power BI or Power Query it’s easy to reference the values in other columns. A slightly more difficult question, however, is how can you re…
Use R to export data from Power BI (and Power Query) #PowerBI #powerquery #PowerPivot
One of the first concepts to learn in DAX is the difference between calculated columns and measures. This article shortly recap the differences.
Excel users who start to learn Power Query will find learning R quite easy once they’ve started to play around with Power Queries M code. Smooth transition!
Apply AND Logic to Multiple Selection in DAX Slicer – SQLBI http://www.sqlbi.com/articles/apply-and-logic-to-multiple-selection-in-dax-slicer/ (Κοινή χρήση από CM Browser)
What we have to do if our source is a mix of tabular data and important values outside the tables? We need to transfer this values to a new column in the tables