Results for "DAX"
9 / 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 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 = *…
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…