#Excel Super Links #14 – shared by David Hager

I will likely end this daily series of Super Links at issue #20, but will continue to add issues as available.

Calculating Pearson Correlation Coefficient using DAX

http://blog.gbrueckl.at/2015/06/calculating-pearson-correlation-coefficient-dax/

Compare equivalent periods in DAX

https://www.sqlbi.com/articles/compare-equivalent-periods-in-dax/

Excel udf: Fuzzy lookups

http://www.get-digital-help.com/2011/04/04/excel-udf-fuzzy-lookups/

Extract Data from a Mixed Column with Power Query

http://www.excelguru.ca/blog/2016/11/30/extract-data-from-a-mixed-column/

Scaling in-cell charts with an Excel formula

https://dhexcel1.wordpress.com/2014/01/07/scaling-in-cell-charts-with-an-excel-formula/

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s