Trending and Smoothing at PASS BA Conference 2016 – PowerPivotPro

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…

Πηγή: Trending and Smoothing at PASS BA Conference 2016 – PowerPivotPro

Compare two tables or reports using Power Query – Excel and Power BI

I receive a lot of reports on a daily, weekly or monthly basis.  Usually the reports are little changed from the previous version but there is no easy way to work out just what has changed.  I susp…

Πηγή: Compare two tables or reports using Power Query – Excel and Power BI

Dynamic Column Selection In Custom Columns In Power BI/Power Query/M – Chris Webb’s BI Blog

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…

Πηγή: Dynamic Column Selection In Custom Columns In Power BI/Power Query/M – Chris Webb’s BI Blog

Power Query & Power BI are ideal learning paths from Excel to R – The BIccountant

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!

Πηγή: Power Query & Power BI are ideal learning paths from Excel to R – The BIccountant