Results for "Power BI"
14 / 184 posts
Basic of DAX query
// How to check null ISBLANK(EmployeeDetails[DateofLeaving]) //if condition IF(ISBLANK(EmployeeDetails[DateofLeaving]),TODAY(),EmployeeDetails�…
What is Power BI
Power BI is a suite of business analytics tools developed by Microsoft that allows you to visualize and share insights from your data. Power BI consists of…
What is RLS (Row-Level Security) in Power BI
RLS stands for Row-Level Security, which is a feature in Power BI (and also in SQL Server Analysis Services) that allows you to restrict data access at the…
What is Data tables(Fact Tables) vs Lookup tables(Dimension Tables)
Data Tables(Fact Tables) Purpose : Store detailed, raw data. Structure : Multiple columns (attributes) and rows (records). Example : A table with order det…
DAX (Data Analysis Expressions) Operators and Data Type in Power BI
Here's the list of DAX operators in a table format: Arithmetic Operators Operator Description Example + Addition = + - Subtraction = - * Multiplication = *…
Basic Functions in Power BI
SUMX : This function is used to evaluate an expression for each row. It's useful when you need to perform calculations on a row-by-row basis before aggrega…
Advance functions in Power BI
ALL Filter: The ALL filter returns all the rows in a table or all the values in a column, ignoring any filters that might have been applied. This function …
Date Time in Power BI
In Power BI and DAX, the CALENDAR() and CALENDARAUTO() functions are used to generate a table of dates. These functions are particularly useful for creatin…
USERELATIONSHIP function In Power
USERELATIONSHIP: This is particularly useful when you have multiple relationships between the same tables but only one can be active at a time. By default,…
How to Create table in Power BI using Dax
ROW: The ROW function in DAX creates a single row table with the specified columns and values. ROW(columnName1, value1, [columnName2, value2], ...) Si…
Calculate and Calculatetable Function in Power BI
CALCULATE : It's used to modify or filter the context in which a calculation is being performed CALCULATE(<expression>, <filter1>, <filter2&…
ALLSELECTED Function in Power BI
ALLSELECTED : The ALLSELECTED function in DAX is used to return all the rows in a table, or all the values in a column . This is particularly useful in sce…
SQL MERGE statement
CREATE DATABASE SqlShackMergeDemo GO USE SqlShackMergeDemo GO CREATE TABLE SourceProducts( ProductID INT, ProductName VARCHAR(50), Price DECIMAL(9,2) ) GO …
Data archive in SQL Server
A data archive refers to the process of moving inactive or less frequently used data from an operational system to a storage system , typically in a separa…