Power BI | DAX | Excel | VBA | Python | SQL

  • All Posts
  • DAX
  • CALCULATE
  • Power BI
  • DAX Studio
  • Tabular Editor
  • Running Totals
  • Visualization
  • Power BI Service
  • DAX Optimizations
  • Power Query
  • M
  • Circular Dependency
  • SQL
  • About Me
  • DAX Functions
  • VBA
  • Excel
  • Tableau
Search
Sales Dashboard in Excel
Antriksh Sharma
  • Jul 19, 2021
  • 1 min

Sales Dashboard in Excel

Tried to replicate Andy Kriebel's Sales Dashboard in Excel. Link to Tableau viz - https://public.tableau.com/app/profile/andy.kriebel/viz...
430
Get Row Number with XLOOKUP in Excel
Antriksh Sharma
  • Jul 9, 2021
  • 1 min

Get Row Number with XLOOKUP in Excel

In this tutorial lets see how you can use XLOOKUP in Excel to find the postion of the Lookup Value in the Lookup Array. Doing this with...
7110
SUM Cells by Color in Excel with VBA
Antriksh Sharma
  • Jul 5, 2021
  • 1 min

SUM Cells by Color in Excel with VBA

In this tutorial lets see how we can SUM cells in Excel with similar colors with the help of VBA. The dataset we are going to use: Now go...
340
  • Blog

  • DAX Functions

  • About Me

  • Dashboards

  • More

    Use tab to navigate through the menu items.