Category Archives: Power BI

#Excel Super Links #42 – shared by David Hager

Creating Infographics with Excel, Part 1

http://www.thinkdatainsights.com/creating-info-graphics-with-excel-part-1/

Web Scraping Power BI Custom Visuals from Office Store

https://datachant.com/2017/05/19/web-scraping-part-3-power-bi-custom-visuals/

Grid of Random Integers in Excel

https://excelxor.com/2015/01/26/grid-of-random-integers/#more-4145

How to edit M-function Documentation Metadata

http://www.thebiccountant.com/2017/05/11/how-to-edit-m-function-metadata/

#Excel: Four Super Filter Techniques by David Hager

https://dhexcel1.wordpress.com/2017/04/15/excel-combining-and-refining-a-static-filter-list-filter-criteria-udf-by-david-hager/

#Excel Super Links #38 – shared by David Hager

100 Excel Tips & Resources to Celebrate 2000 RSS Subscribers

http://chandoo.org/wp/2009/01/28/100-excel-tips-resources-to-celebrate-2000-rss-subscribers/

Power BI Desktop/DAX – Using Unicode (Arrows) as Measures in a Table

https://gqbi.wordpress.com/2017/05/16/power-bi-desktopdax-using-unicode-arrows-as-measures-in-a-table/

Reverse two-way Lookup in a Cross Reference Table

http://www.get-digital-help.com/2017/05/16/reverse-two-way-lookup-in-a-cross-reference-table/

The Excel VBA Code Cleaner

http://appspro.com/Utilities/CodeCleaner.htm

#Excel For You Blog Posts Containing Downloadable Workbook Files by David Hager

https://dhexcel1.wordpress.com/2017/05/16/excel-for-you-blog-posts-containing-downloadable-workbook-files-by-david-hager/

 

Generating Random Initials with DAX in Power BI by David Hager

After publishing a short article about generating random initials in Excel

https://dhexcel1.wordpress.com/2017/05/18/excel-short-and-sweet-tip-14-generating-random-initials-by-david-hager/

I wanted to see if the same formula worked in Power BI. When I entered the aforementioned formula into a calculated column in Power BI desktop, I got an error message. After some research, I discovered that was no CHAR function in the DAX function reference. Then, I remembered that Chris Webb showed examples of the new UNICHAR function at the following link.

https://blog.crossjoin.co.uk/2017/04/11/the-dax-unichar-function-and-how-to-use-it-in-measures-for-data-visualisation/

And, Chris discovered that the UNICHAR function was completely undocumented and was probably introduced in the April 2017 update. So, I changed my random initials formula using UNICHAR instead of CHAR, and it worked.

=UNICHAR(INT(RAND()*26)+65)&UNICHAR(INT(RAND()*26)+65)&UNICHAR(INT(RAND()*26)+65)

Now, you can use this in your Power BI projects.

It is still a mystery how DAX could be around for 8 years and not have the CHAR function (or its equivalent).

 

#Excel Super Links #37 – shared by David Hager

PivotTables Just Got Personal

https://blogs.office.com/2017/05/15/pivottables-just-got-personal/

Dynamic distances in Power BI

https://philseamark.wordpress.com/2017/05/13/dynamic-distances-in-power-bi/

Filter a BI report with a URL query string parameter

https://powerbi.microsoft.com/en-us/blog/filter-a-report-with-a-url-query-string-parameter/

Excel XML – Dynamic Periodic Table

http://blog.excelhero.com/2011/06/01/excel_xml_dynamic_periodic_table/

#Excel Short and Sweet Tip #12 (Documenting Formulas and Highlighting Those Formulas With Conditional Formatting) by David Hager

https://dhexcel1.wordpress.com/2017/05/13/excel-short-and-sweet-tip-12-documenting-formulas-and-highlighting-those-formulas-with-conditional-formatting-by-david-hager/

 

#Excel Super Links #36 – shared by David Hager

Interactive Bullet Graphs in Excel

http://www.clearlyandsimply.com/clearly_and_simply/2017/05/interactive-bullet-graphs-in-excel.html

The Ultimate Guide to Slopegraphs in Excel

https://exceloffthegrid.com/the-ultimate-guide-to-slopegraphs-in-excel/

An Index of Excel Tips

https://excelprovegue.wordpress.com/index/

Performance difference between Excel and PowerBI with M is huge!

http://www.thebiccountant.com/2017/05/14/performance-considerations-for-bom-solution-in-excel-and-powerbi/

#Excel: Finding and Visualizing the Last Record in a Table Based on Criteria by David Hager

https://dhexcel1.wordpress.com/2017/05/14/excel-finding-and-visualizing-the-last-record-in-a-table-based-on-criteria-by-david-hager/

 

#Excel Super Links #34 – shared by David Hager

SUMIFS Formula With Empty Criteria Cells

http://blog.contextures.com/archives/2017/04/13/sumifs-formula-with-empty-criteria-cells/

Tip – Create several AutoSum Measures in with one click #Excel Power Pivot – #powerbi

https://eriksvensen.wordpress.com/2017/04/14/tip-create-several-autosum-measures-in-with-one-click-excel-power-pivot-powerbi/

Interpolate values using the FORECAST function

https://exceloffthegrid.com/interpolate-values-using-the-forecast-function/

Excel Magic Trick 1415: Power Query Lookup and Return Multiple Items And Join Them In Single Cell

https://www.youtube.com/watch?v=KRqIEfwWLQs

Excel 2013: Power Query OmniQueries. Dynamic And Refreshable Connections To The Data Model

https://dhexcel1.wordpress.com/2014/02/05/excel-2013-power-query-omniqueries-dynamic-and-refreshable-connections-to-the-data-model/

 

#Excel Super Links #33 – shared by David Hager

How to Use Microsoft Excel Fuzzy Lookup Add-in

https://www.youtube.com/watch?v=3v-qxcjZbyo

Use VBA to automate Power Query in Excel 2016

https://gallery.technet.microsoft.com/office/VBA-to-automate-Power-956a52d1

Old Japanese Man Creates Amazing Art Using Excel (Wait, Excel?)

http://kotaku.com/old-japanese-man-creates-amazing-art-using-excel-wait-499616608

SUMX() – The 5-point Palm, Exploding fxn Technique

https://powerpivotpro.com/2010/02/sumx-the-5-point-palm-exploding-fxn-technique/

TEXTJOIN: Multiple Lookup Values in a Single Cell (With/Without Duplicates) Using Only #Excel Formulas by David Hager

https://dhexcel1.wordpress.com/2017/04/04/multiple-lookup-values-in-a-single-cell-withwithout-duplicates-using-only-excel-formulas-by-david-hager/