Export Measures and Calculated columns
Documenting DAX formulas is always a good practice as it saves a lot of time in various scenario such as when your PBI report having… Read More »Export Measures and Calculated columns
Home ยป
Power BI DAX
Power BI DAX : Data Analysis Expression (DAX), According to Microsoft Documentation DAX is a collection of functions, operators, and constants that can be used in a formula, or expression, to calculate and return one or more values. Stated more simply, DAX helps you create new information from data already in your model.
LOOKUPVALUE function DAX
LOOKUPVALUE function is a Power BI Filter function in DAX, it returns the value for the row that meets all criteria specified by one or… Read More »LOOKUPVALUE function DAX
OPENINGBALANCEMONTH Function DAX
OPENINGBALANCEMONTH function is a Power BI time intelligence DAX function which evaluates evaluates the specified expression for the date corresponding to the end of the… Read More »OPENINGBALANCEMONTH Function DAX
CLOSINGBALANCEMONTH function DAX
CLOSINGBALANCEMONTH function is a Power BI time intelligence DAX function which evaluates the expression at the last date of the month in the current context.… Read More »CLOSINGBALANCEMONTH function DAX
Export data from SQL Server to an Excel file
Sometimes you need to export data from SQL Server tables, views or the result of any T-SQL query into excel file, reason could be anything… Read More »Export data from SQL Server to an Excel file
Create a Data Profiling report
The data profile allows a intuitive ways to clean, transform, and understand data which helps you identifying the nuances of the data such as determining… Read More »Create a Data Profiling report
Profile Data in Power BI
The data profiling allows a intuitive ways to clean, transform, and understand data in Power Query Editor, which helps you identifying the nuances of the… Read More »Profile Data in Power BI
LASTNONBLANK function DAX
LASTNONBLANK function is a Power BI time intelligence function in DAX which returns the last value in the column filtered by the current context for… Read More »LASTNONBLANK function DAX
TRUNC function DAX
TRUNC function is a Power BI math and trig function in DAX, which truncates a number to an integer by removing the decimal, or fractional… Read More »TRUNC function DAX
LOWER function DAX
LOWER function is a Power BI text functions which converts a text string to all lowercase letters. SYNTAX LOWER (<text>) text is the text you… Read More »LOWER function DAX
UPPER Function DAX
UPPPER function is a Power BI text functions which converts a text string to all uppercase letters. SYNTAX UPPER (<text>) text is the text you… Read More »UPPER Function DAX
MID Function DAX
MID function is a Power BI text functions in DAX, it returns a string of characters from the middle of a text string based on… Read More »MID Function DAX
FORMAT Function DAX
FORMAT function is a Power BI text function in DAX, which converts a value to text according to the specified format. Syntax FORMAT(<value>, <format_string>) value… Read More »FORMAT Function DAX
Install and Configure on-premises data gateway (personal mode)
The on-premises data gateway acts as a bridge to provide quick and secure data transfer between on-premises data basically a data that is not in… Read More »Install and Configure on-premises data gateway (personal mode)
REMOVEFILTERS Function DAX
REMOVEFILTER function is a Power BI filter function in DAX, It removes filters from the specified tables or columns. It can only be used to… Read More »REMOVEFILTERS Function DAX
TOTALYTD Function DAX
TOTALYTD is a Power BI time intelligence function in DAX, which evaluates the year-to-date value of the expressionย in the current context. DAX SYNTAX TOTALYTD(<expression>,<dates>[,<filter>][,<year_end_date>]) expression… Read More »TOTALYTD Function DAX
REPLACE Function DAX
REPLACE function is a Power BI text function in DAX, which replaces part of a text string based on the number of characters you specify,… Read More »REPLACE Function DAX
Calculated Columns
Microsoft Power BI allows you to create a calculated columns means you can add a new column to an existing table in your data model,… Read More »Calculated Columns
PATHITEM Function DAX
PATHITEM function is a Power BI parent and child function in DAX which returns the item at the specified position from a string resulting from… Read More »PATHITEM Function DAX
PATHLENGTH Function DAX
PATHLENGTH function is a Power BI parent and child function in DAX, which returns the number of parents to the specified item in a given… Read More »PATHLENGTH Function DAX