Antriksh Sharma
Using Python to Execute DAX Queries in Power BI & SSAS Tabular - Part 1
In this blog let's take a look at how you can use Python to connect to either Power BI or SQL Server Analysis Services to run DAX...
top of page
Power BI | Excel | Python | SQL
Search
Antriksh Sharma
- Feb 6, 2022
- 1 min
Course: Tabular Editor 3
Last year we released a course on one of the most famous development tool for Power BI, check out the interview I had with EDNA.
640
Antriksh Sharma
- Jan 16, 2022
- 0 min
440
Antriksh Sharma
- Dec 20, 2021
- 2 min
Storing a column as String or Integer in Analysis Services
Recently someone asked a question that whether they should store a column in a Tabular model in String or Integer format and in this...
3850
Antriksh Sharma
- Nov 18, 2021
- 4 min
Dependency of a function on Row Context in DAX
Have you ever writen a piece of DAX Code that looks like this: and ended up confused how is it able to calculate how many years, days,...
5610
Antriksh Sharma
- Oct 12, 2021
- 2 min
Implementing Object Level Security in Power BI
In this blog lets see how we can implement OLS or Object Level Security in Power BI. In simple terms the difference between RLS and OLS...
3580
Antriksh Sharma
- Oct 6, 2021
- 2 min
Create a Date table in Power Query with M code
Having a complete date table in your SSAS model is extremely important, a complete Date table helps in ensuring that the time...
1,4990
Antriksh Sharma
- Sep 26, 2021
- 3 min
How to extract measures from Power BI to Excel or Text file?
A very common scenario in Power BI is of extracting measure into text file and then loading them back again in the Power BI file so that...
2,6360
Antriksh Sharma
- Sep 16, 2021
- 1 min
Tabular Editor 3 Course
TE3 is the ultimate development tool for creating Tabular Model and recently I got an opportunity to make a full fledged course on it for...
930
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...
2,4020
Antriksh Sharma
- Sep 1, 2021
- 4 min
SUM vs SUMX in DAX
SUM and SUMX are both aggregation functions in DAX. While SUM allows you to aggregate only one Physical column of a table, SUMX is more...
1,8490
Antriksh Sharma
- Aug 26, 2021
- 1 min
Create Lollipop chart in Tableau
I am always amazed by the capabilities of Tableau to create visuals that are difficult to create in different tools such as Power BI. In...
600
Antriksh Sharma
- Aug 11, 2021
- 1 min
Ecommerce Dashboard in Power BI
Recently participated in the Onyx Ecommerce challenge on LinkedIn and made this dashboard, nothing too fancy it is just something I made...
4140
Antriksh Sharma
- Aug 3, 2021
- 2 min
Previous Year calculation in case of missing years in DAX.
One of the most common time intelligence calculations that I see in each report is that of Previous Year, this calculation is pretty easy...
7230
Antriksh Sharma
- Jul 23, 2021
- 2 min
How to Load Data From Power BI into SQL Server?
Whenever I work with LinkedIn data challenges a very common task for me is to load data into SQL Server as modifying the data in SQL is...
7290
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...
1070
Antriksh Sharma
- Jul 12, 2021
- 4 min
How to create Running Total in Power BI: The Basics
In this tutorial lets see how easy it is to create a running total in DAX either in SSAS, Power Pivot or Power BI. Running total is a...
4,7900
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...
3,5610
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...
1140
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...
3,8041
Antriksh Sharma
- Jun 30, 2021
- 1 min
Show measures in Power BI based on slicer selection
One of the very common requirement of Power BI users is that of showing only those measures in a visual which are selected in a slicer....
1600
Antriksh Sharma
- Jun 24, 2021
- 1 min
Create relationships in Power BI with Tabular Editor
Creating relationships in Power BI is as simple as it can get but to be able to edit/create relationships in Power BI with TE is...
1,5901
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...
5080
Antriksh Sharma
- Jun 8, 2021
- 1 min
Create Calculated Table in Power BI with Tabular Editor
Out of the box TE doesn't allows you to create Calculated Table in Power BI, but if you want you can easily do that. To be able to create...
7780
bottom of page