Skip to content (Press Enter)
  • Home
  • Services
  • Blog
  • Case Studies
  • About Me
Macrordinary

Macrordinary

  • Home
  • Services
  • Blog
  • Case Studies
  • About Me
Home>filter

Tag: filter

Updated on November 8, 2020November 8, 2020/ Brent Allen

Top N Results from Excel using Dynamic Arrays

Top N Results from Excel using Dynamic Arrays

Getting the Top N results from a list of data, such as a Top 10 list is a very common Excel request. While this was possible before dynamic arrays, it has been made much easier using dynamic arrays. In this …

Read More
Updated on January 25, 2020January 2, 2020/ Brent Allen

Power Query – Clean data for the Data Model

Power Query – Clean data for the Data Model

In previous exercises, we used the FILTER() function in order to remove the totals from our data model. Using Power Query, clean data is provided to the data model. Filtering before the data model improves the performance of the model, …

Read More
Updated on December 15, 2019December 9, 2019/ Brent Allen

FILTER and CALCULATE – Removing pre-calculated totals.

FILTER and CALCULATE – Removing pre-calculated totals.

In the last post, we started using the CALCULATE() function to filter out some of the values that we didn’t want on our totals. This was done in order to get a pivot table that didn’t need to use the …

Read More

Recent Posts

  • Non-Unique List in Excel: Showing Only Duplicates
  • BYROW() in Excel: A Marginal Tax Schedule Example
  • Unique Values from 2 Lists in Excel – Multiple Methods
  • LAMBDA() in Excel – Generating an Amortization Schedule
  • LET Function in Excel: A Name Parsing Example

Categories

  • dashboards
  • excel
  • financial formulas
  • formulas
  • M
  • office script
  • pivot tables
  • power apps
  • power bi
  • power pivot
  • power platform
  • power query
  • scripts
  • VBA
Copyright © 2025 Macrordinary. Software Company | Developed By Rara Theme. Powered by WordPress.