Power BI is a business analytics service by Microsoft. It provides interactive visualizations and business intelligence capabilities with an interface simple enough for end users to create their own reports and dashboards.
Power Query is a very powerful tool. It has many inbuilt functions that helps you in data transformation and data preparation. Error Handling allows you… Read More »Error handling in Power Query
627 total views, 25 views today
This article demonstrate how to create a custom function in Power Query that returns the difference of two dates. Custom function takes a set of… Read More »Create custom function to get two dates difference
180 total views
Whenever you do a transformation in Power Query, it adds a steps for each transformations. It is always a good practice to add a short… Read More »Add comments to Power Query steps
237 total views
This article demonstrate how to handle NULL values in data. Having null values in data may impact calculations and produce wrong result. As you can… Read More »Handle NULL values in Power Query
340 total views, 2 views today
Power Query allows you to replace any values with new values, you might have used power query replace values option which replace the old value… Read More »Replace multiple values in one column Power Query
920 total views, 3 views today
Power Query helps you to transform your data, there are various in-built Power Query M code function that can be useful to transform you data… Read More »Add Prefix and Suffix to Value in Power Query
782 total views, 1 views today
A running totals or cumulative totals is a sequence of partial sum of values in any given table. It just add up the values as… Read More »Running totals in Power Query
242 total views
Removing the matching rows or occurrence of specified rows from the table using Power query is very easy as Power Query provides in-built function named… Read More »Remove matching rows using Power Query
656 total views, 4 views today
A PBIX, PBIT, and PBIDS are file extensions used in Microsoft Power BI. Lets explore and see the difference between each of them one by… Read More »Difference between PBIX, PBIT and PBIDS file format in Power BI
903 total views
This article demonstrate how to get the difference between to dates in Power Query. You can use the Power Query Duration function that is Duration.Days… Read More »Difference between two dates in Power Query
302 total views
Date functions helps you to create and manipulate the part of date such as date, datetime, and datetimezone values. There are various inbuilt date functions… Read More »Date Functions in Power Query
358 total views
This article demonstrate how to replace multiple columns value at once in Power Query. Lets say, you need to check if column value is blank… Read More »Replace multiple columns values in Power Query
306 total views
In this article we will see how to remove duplicate record and keep the latest record in table using Power Query. As you can see… Read More »Remove duplicate and keep latest record in table
349 total views, 2 views today
In this article we will demonstrate how to display last n months data in chart based on selected month in slicer. Means, user will select… Read More »Display Last N months data in Power BI
3,011 total views, 3 views today
In this article we will see how to display the TOP N and Others in Power BI, means to show the top n products and… Read More »TOP N and Others in Power BI
2,435 total views, 6 views today
Power BI released a new preview feature called Field Parameters in May 2022 update. Using Field Parameters you can dynamically change the measure or dimension… Read More »Field Parameter in Power BI
1,137 total views, 2 views today
You can create a dynamic title based on values selected in slicers or can show slicer selected values in text box. Lets create a dynamic… Read More »Creating Dynamic Title based on Slicer Selection
643 total views, 2 views today
You can check multiple values in any list using IN operator in Power Query. Lets say, you have a requirement to check for specific categories… Read More »IN operator in Power Query M code
1,416 total views, 1 views today
Ribbon chart is used to visualize the data and quickly identify which data category has the highest rank (largest value). Ribbon charts are effective at… Read More »Ribbon Chart in Power BI
2,566 total views, 2 views today
Power BI 100% stacked bar chart is used to display relative percentage of multiple data series in stacked bars, where the total (cumulative) of each stacked bar always… Read More »100% Stacked bar chart in Power BI
2,713 total views, 4 views today