Category Archives: PowerPivot DAX

#Excel Super Links #103 – shared by David Hager

 

DAX KEEPFILTERS Plus Bonus Complaining!

http://tinylizard.com/dax-keepfilters/

When to Use SUM() vs SUMX()

https://exceleratorbi.com.au/use-sum-vs-sumx/

SQL-query folding bug still alive and sucking in PowerBI and PowerQuery in Excel

http://www.thebiccountant.com/2017/07/20/sql-query-folding-bug-still-alive-sucking-powerbi-powerquery-excel/

Related Distinct Count in DAX

http://www.daxpatterns.com/distinct-count/

Storing and Running M Code from #Excel Worksheet Cells by David Hager

https://dhexcel1.wordpress.com/2017/07/20/storing-and-running-m-code-from-excel-worksheet-cells-by-david-hager/

#Excel Super Links #102 – shared by David Hager

 

Using Power BI to Extract Data from Office 365 Reporting Web Services

https://eriksvensen.wordpress.com/2014/11/10/using-power-bi-to-extract-data-from-office-365-reporting-web-services-powerbi-office365/

Stick a Drop Pin in It: Visualize Data With Maps (DAX Reanimator Series: Part 2)

https://powerpivotpro.com/2017/07/visualize-data-with-maps-dax-reanimator-series-part-2/

Built In and Custom Lists in Excel

https://peltiertech.com/built-in-custom-lists-excel/

How To Customize The Order Of Your Excel Slicer Buttons

https://www.thespreadsheetguru.com/blog/how-to-customize-order-of-excel-slicer-buttons

Bible Verse In Any Language Using #Excel by David Hager

https://dhexcel1.wordpress.com/2017/07/13/lookup-a-bible-verse-in-any-language-using-excel-by-david-hager/

 

 

#Excel Super Links #101 – shared by David Hager

 

Why does the calculation mode keep changing?

https://exceloffthegrid.com/why-does-the-calculation-mode-keep-changing/

Variations of Alternative Bullet Graphs in Excel

http://www.clearlyandsimply.com/clearly_and_simply/2017/07/variations-of-alternative-bullet-graphs-in-excel.html

Row Context and Filter Context in DAX

https://www.sqlbi.com/articles/row-context-and-filter-context-in-dax/

Browser automation in Excel VBA using Selenium

https://codingislove.com/browser-automation-in-excel-selenium/

#Excel Short and Sweet Tip #27 (Use Worksheet UDF to Add Background to #Excel Worksheet) by David Hager

https://dhexcel1.wordpress.com/2017/07/17/excel-short-and-sweet-tip-27-use-worksheet-udf-to-add-background-to-excel-worksheet-by-david-hager/

 

#Excel Super Links #100 (Special Edition) – shared by David Hager

 

My Top 10 Most Underviewed Posts (IMO)

Please check out these posts on my website. There are some powerful techniques to be found here.

#Excel: Getting the Sunrise and Sunrise Times From an Address by David Hager

https://dhexcel1.wordpress.com/2017/07/11/excel-getting-the-sunrise-and-sunrise-times-from-an-address-by-david-hager/

#Excel: Removing Outliers with Excel Formulas to Modify Control Limits by David Hager

https://dhexcel1.wordpress.com/2017/05/17/excel-modifying-control-chart-data-to-remove-outliers-with-excel-formulas-by-david-hager/

#Excel: Using Conditional Formatting to Highlight 3D Formulas with Defined Names by David Hager

https://dhexcel1.wordpress.com/2017/04/25/excel-using-conditional-formatting-to-highlight-3d-formulas-with-defined-names-by-david-hager/

Getting the Latest Earthquake Alert Using the WEBSERVICE and FILTERXML Functions in #Excel by David Hager

https://dhexcel1.wordpress.com/2017/07/10/getting-the-latest-earthquake-alert-using-the-webservice-and-filterxml-functions-in-excel-by-david-hager/

Creating a Unique Delimited String from an Excel Filtered List by Using the TEXTJOIN Function By David Hager

https://dhexcel1.wordpress.com/2017/01/08/creating-a-unique-delimited-string-from-an-excel-filtered-list-by-using-the-textjoin-function-by-david-hager/

Excel: Conditional Format Rows in List 1 that are Not in List 2 by David Hager

https://dhexcel1.wordpress.com/2017/06/25/excel-conditional-format-rows-in-list-1-that-are-not-in-list-2-by-david-hager/

#Excel Short and Sweet Tip #17 (Returning a Letter Grade Based on a Normal Grading Scale Without Lookup Table) by David Hager

https://dhexcel1.wordpress.com/2017/05/26/excel-short-and-sweet-tip-16-returning-a-letter-grade-based-on-a-normal-grading-scale-without-lookup-table-by-david-hager/

The DAX ENDSWITHX Function Equivalent

https://dhexcel1.wordpress.com/2015/06/21/the-dax-endswithx-function-equivalent/

Returning the First Temperature in PowerPivot

https://dhexcel1.wordpress.com/2014/05/25/returning-the-first-temperature-in-powerpivot/

#Excel Short and Sweet Tip #25 (Random Sound – Worksheet UDF) by David Hager

https://dhexcel1.wordpress.com/2017/07/07/excel-short-and-sweet-tip-25-playing-a-random-sound-with-a-worksheet-udf-by-david-hager/

 

 

#Excel Super Links #99 – shared by David Hager

 

Calculate the Sum of Varying Ranges Based on a Condition and Across Multiple Sheets

http://www.xl-central.com/blog.html#complex-sum

Specify a dis-contiguous range for an Excel function argument

http://www.tushar-mehta.com/excel/tips/multi_area_argument.html

Transparent UserForm Background with VBA

http://wellsr.com/vba/2017/excel/transparent-userform-background-with-vba/

Handling Different Granularities In DAX

http://www.daxpatterns.com/handling-different-granularities/

Excel Short & Sweet Tip #7(Highlighting External Links) by David Hager

https://dhexcel1.wordpress.com/2017/04/28/excel-short-sweet-tip-7highlighting-external-links-by-david-hager/

#Excel Super Links #98 – shared by David Hager

 

Power Query – Adding null to values returns null

https://www.excelguru.ca/blog/2017/07/12/adding-null-to-values-returns-null/

Power BI – When is the Best Day to See Your Favorite Baseball Team?

https://blogs.msdn.microsoft.com/deeperinsights/2017/07/13/when-is-the-best-day-to-see-your-favorite-baseball-team/

The Calendar Table (Date Dimension) Explained for Power Pivot & Power BI

https://www.excelcampus.com/tables/calendar-table-explained/

Always Use Stored Procedures

http://dailydoseofexcel.com/archives/2017/07/13/always-use-stored-procedures/

Lookup a Bible Verse In Any Language Using #Excel by David Hager

https://dhexcel1.wordpress.com/2017/07/13/lookup-a-bible-verse-in-any-language-using-excel-by-david-hager/

 

#Excel Super Links #96 – shared by David Hager

 

Using the SELECTEDVALUE function in DAX

https://www.sqlbi.com/articles/using-the-selectedvalue-function-in-dax/

Lookup the Second, the Third, or the Nth Value in Excel

https://trumpexcel.com/lookup-second-value/

Non-linear Break-Even Analysis in PowerBI

http://www.thebiccountant.com/2017/07/11/non-linear-break-even-analysis-in-powerbi/#more-2347

Everything you need to know about the VLOOKUP function

http://www.get-digital-help.com/2017/07/11/everything-you-need-to-know-about-the-vlookup-function/

A Lot More to See Here Since I Trashed a Bunch of Posts (150, to be exact)

https://dhexcel1.wordpress.com/feed/