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 more search conditions. SYNTAX LOOKUPVALUE( <result_columnName>, <search_columnName>, <search_value> [, <search2_columnName>,…

 50 total views,  6 views today

Read More...

Data Alerts in Power BI service


Set alerts in the Power BI service to notify you when data on a dashboard changes above or below limits you set. Alerts can only be set on tiles pinned from report visuals, and only…

 344 total views,  1 views today

Read More...

Install and Configure on-premises data gateway


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 the cloud and several Microsoft cloud services. There are two…

 362 total views,  4 views today

Read More...

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 previous month after applying all the filters. SYNTAX OPENINGBALANCEMONTH(<expression>,<dates>[,<filter>]) expression…

 133 total views,  1 views today

Read More...

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. SYNTAX CLOSINGBALANCEMONTH(<expression>,<dates>[,<filter>]) expression is an expression that returns a scalar…

 351 total views,  2 views today

Read More...

Add a columns from examples in Power BI


Power Query add column from examples feature, allows you to add new columns to data model simply by providing one or more example values for the new columns. You can either create the new column…

 331 total views

Read More...

Append Queries in Power BI


The append operation in Power Query creates a single table by adding the contents of one or more tables to another, and aggregates the column headers from the tables to create the schema for the…

 534 total views,  2 views today

Read More...

Unpivot Columns in Power BI


Power Query provides a feature that is Unpivot columns which allows you to transform columns into attribute-value pairs, where columns become rows. Columns that you unpivot are split in two columns that are Attribute and…

 456 total views,  1 views today

Read More...

Fill values in column in Power BI


Power Query provides a FILL operation which allows you to fill up and fill down to replace null values with the last non-empty value in a column. Lets look at an example of using a…

 310 total views,  3 views today

Read More...

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 anomalies, examining and developing the underlying data structures, and querying…

 149 total views,  2 views today

Read More...

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 data such as determining anomalies, examining and developing the underlying…

 437 total views

Read More...

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 which the expression has a non blank value. It returns…

 417 total views,  1 views today

Read More...

Row-Level Security (RLS) in Power BI


Row-Level security (RLS) is a feature of Power BI that can be used to restrict data access for given users, so the appropriate person can see the appropriate records. Row-Level security uses a DAX filters…

 546 total views,  7 views today

Read More...

Custom function in Power BI


Custom function in Power BI allows you to use a same piece of code repeatedly multiple times. Sometime, you may get a situation where you need to use the same set of transformations to different…

 569 total views

Read More...

Monitor usage and performance in workspace


This is a performance and usage metrics features that you can use in a workspace. Using these metrics, you can view who is using your reports, how they are using the report, what actions are…

 251 total views,  1 views today

Read More...

Power BI Report Performance Analyzer


Performance Analyzer is a tool within Power BI desktop, that allows you assess your report’s performance and identify area of improvement. Using this you can identify the time taken by each visual to query for…

 480 total views,  2 views today

Read More...

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 part of the number. TRUNC function does not round the…

 326 total views,  2 views today

Read More...

Import JSON data files in Power BI


Microsoft Power BI allows us to connect with multiple data sources such as SQL Server, Excel, Text/Csv, XML, Pdf, and JSON and many more, here we will focus on how to import JSON data file…

 704 total views,  7 views today

Read More...

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 want converted to lowercase, or a reference to a column…

 131 total views,  1 views today

Read More...

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 want converted to uppercase, or a reference to a column…

 122 total views,  1 views today

Read More...