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
How To Load Data In Power BI With Stored Procedure and Parameters
Antriksh Sharma
  • Sep 3, 2021
  • 1 min

How To Load Data In Power BI With Stored Procedure and Parameters

In this blog let's see how we can combine Stored Procedure and Parameters to load data into PBI. First we need to create a very basic...
2650
Dynamically Remove Null Columns in Power Query with M code
Antriksh Sharma
  • Jul 1, 2021
  • 2 min

Dynamically Remove Null Columns in Power Query with M code

I was recently working with a dataset and found that there were a lot of columns that were completely null, now going 1 by 1 through each...
1,5441
Dynamically change column names in Power Query using predefined values
Antriksh Sharma
  • Jun 17, 2021
  • 1 min

Dynamically change column names in Power Query using predefined values

In Power Query if you want to change names of columns you can easily do so by going through each column one by one and then renaming...
840
Clean a string using M in Power Query
Antriksh Sharma
  • May 3, 2021
  • 1 min

Clean a string using M in Power Query

In this blog I am going to show you how you can remove unwanted characters all at once from an improper text string like the following...
880
  • Blog

  • DAX Functions

  • About Me

  • Dashboards

  • More

    Use tab to navigate through the menu items.