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

Macrordinary

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

Tag: calculate

Updated on December 16, 2019December 17, 2019/ Brent Allen

ALL() and CALCULATE() – Percentage of a column

ALL() and CALCULATE() – Percentage of a column

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
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
Updated on December 5, 2019November 22, 2019/ Brent Allen

Sum of a row using CALCULATE()

Sum of a row using CALCULATE()

In the last post, we created a custom field in the Excel data model; however, we still needed to use Excel formulas to calculate the percentage of a row. In this example, we will be using a simple CALCULATE() function …

Read More

Recent Posts

  • LET Function in Excel: A Name Parsing Example
  • Make a KPI Card like Power BI – In Excel!
  • Top N Results from Excel using Dynamic Arrays
  • DA-100 – The Certified Data Analyst Exam
  • Ranges in Office Script – They are different than VBA!

Categories

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