Reset Identity column value
An identity column in table generates key values automatically based on the current seed and increment, and the benefit of creating an identity column is… Read More »Reset Identity column value
69 total views
I have 8+ years of working experience in Business Intelligence Data Modelling, Power BI, SQL Server, SSRS, SSIS, Azure Data Factory, Power Apps.
An identity column in table generates key values automatically based on the current seed and increment, and the benefit of creating an identity column is… Read More »Reset Identity column value
69 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
121 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
132 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
142 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
160 total views
The SQL NOT EXISTS Operator is used to check the existence of any record in a subquery. The NOT EXISTS operator returns true if the… Read More »SQL NOT EXISTS
271 total views, 1 views today
This article demonstrate how to change item color based on value in gallery. As you can see, here we have a gallery which contains employee… Read More »Change gallery item color based on value in power apps
364 total views, 1 views today
This Article demonstrate how to sort items in gallery control based on item value. You can sort values either in ascending or descending order. You… Read More »Sort Items in gallery Power Apps
111 total views
This article demonstrates how to highlight the selected item in gallery control in Power Apps. As you can see below app screen, there is one… Read More »Highlight selected item in gallery power apps
817 total views, 1 views today
This article demonstrates how to validate if email is not in correct format in Power Apps. It is must to have validation on data while… Read More »Email Validation in Power Apps
274 total views
Write an SQL query to report the nthย highest salary from the Employee table. If there is no nthย highest salary, the query should report null. Table:… Read More »SQL Leet Code Nth Highest Salary Problem
336 total views
SQL Leet code problem: Rank Scores Write an SQL query to rank the scores. The ranking should be calculated according to the following rules: The… Read More »SQL Leet Code Rank Scores Problem
357 total views
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
1,422 total views
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
1,098 total views
You can convert multiple rows into a single comma separated row, it can done by multiple ways using inbuilt SQL functions. As you can see… Read More »How to get multiple row data in single row in SQL
3,885 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
828 total views
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
438 total views
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
792 total views
Rolling average is a calculation to analyze data by creating series of average of different subsets of the entire data. For example, you have data… Read More »Rolling average in SQL
1,781 total views, 2 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
1,636 total views, 1 views today