Antriksh Sharma
445, 454, or 544 Week table in Power BI and Excel
I was looking for a good week based date table on Internet and found only 1-2 but I didn't find columns that I needed, so my search ended...
top of page
Power BI | Excel | Python | SQL
Search
Antriksh Sharma
- Feb 5
- 3 min
Extract model.bim file from Power BI & SSAS Tabular with Python
Model.bim is a JSON file which is the skeleton of your Power BI or SSAS Model, using this file you can create a database from scratch,...
1350
Antriksh Sharma
- Jan 8
- 3 min
Generate custom Contoso Database for SQL Server by SQLBI - ELI5
I this blog I want to show how you can use the Contoso Generator from SQLBI - Contoso Data Generator There are quite a few options that...
1190
Antriksh Sharma
- Mar 28, 2022
- 5 min
Full Outer Join in DAX in Power BI and SSAS Tabular
DAX language of Power BI and SSAS Tabular doesn't have a function for Full Outer Join so in this blog we are going to see a work around...
1,1900
Antriksh Sharma
- Mar 10, 2022
- 7 min
Getting started with Aggregations in Power BI - Part 1
In this article let's take a look at how to get started with aggregations feature in Power BI. I will try to explain aggregations in a...
2750
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...
2780
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,...
4570
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...
1,0850
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...
660
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...
8820
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...
4350
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...
3790
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...
2,8840
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...
2,8051
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,0581
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...
1470
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...
4210
Antriksh Sharma
- May 29, 2021
- 5 min
Optimizing calculations involving CROSSJOIN in DAX for Power BI, Power Pivot and SSAS.
In this blog I am going to show you how you can optimize a simple measure involving CROSSJOIN and in the process we are also going to...
1,1860
Antriksh Sharma
- May 24, 2021
- 3 min
Inverse SUM in DAX
In this blog let's see how to compute value of the measure for every other value of a column except for the one that is currently visible...
4760
Antriksh Sharma
- May 12, 2021
- 4 min
ADDCOLUMNS Function in DAX for Power BI, Power Pivot and SSAS
ADDCOLUMNS is a DAX table function that allows user to add new columns to the existing data. It has 3 main Arguments Table - The table on...
2,8550
Antriksh Sharma
- May 7, 2021
- 1 min
SQL to DAX: Select/Project Columns
In this blog let's understand the difference between selecting columns in SQL vs DAX, i am using a fairly simple Product table which...
1460
Antriksh Sharma
- May 4, 2021
- 4 min
Circular Dependency between Calculated Columns in a Table in DAX
In this article let's understand what Circular Dependency is and how it can cause issues when creating Calculated Columns in a Fact table...
1,9560
Antriksh Sharma
- May 2, 2021
- 4 min
Why you shouldn't add a 0 at the end of a DAX code
Power BI allows you to create reports easily by bringing columns from multiple tables or from a single table and by putting those columns...
1920
Antriksh Sharma
- May 1, 2021
- 3 min
Compute PARALLELPERIOD without using PARALLELPERIOD in DAX
PARALLELPERIOD is a DAX function that allows you to shift MONTH, QUARTER, or YEAR based on the the dates visible in the filter context,...
4640
bottom of page