#Excel Super Links #32 – shared by David Hager

Bill of Materials (BOM) Power Query solution in Excel and PowerBI

http://www.thebiccountant.com/2017/05/08/dynamic-bill-of-material-bom-solution-in-excel-and-powerbi/

Calculating Level of Effort (LOE) in Excel

https://sites.google.com/site/beyondexcel/project-updates/calculatinglevelofeffortloeinexcel

Creating a VLOOKUP Function in Power Query

http://www.excelguru.ca/blog/2015/01/28/creating-a-vlookup-function-in-power-query/

Using Variables within DAX

https://powerbi.tips/2017/05/using-variables-within-dax/

#Excel: Generating a Random Sampling From a List Using VBA and the TEXTJOIN Function by David Hager

https://dhexcel1.wordpress.com/2017/05/03/excel-generating-a-random-sampling-from-a-list-using-vba-and-the-textjoin-function-by-david-hager/

 

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