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 such as MIS team need Sales data in excel file…

 274 total views,  17 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…

 59 total views,  1 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…

 289 total views,  6 views today

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…

 297 total views,  5 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…

 70 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…

 64 total views,  2 views today

Read More...

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 a given starting position and length. SYNTAX MID(<text>, <start_num>, <num_chars>)…

 224 total views,  2 views today

Read More...

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 is a value or expression that evaluates to a single…

 340 total views,  5 views today

Read More...

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

 337 total views

Read More...

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 remove filters but not to return a table. SYNTAX REMOVEFILTERS([<table>…

 278 total views

Read More...

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 An expression that returns a scalar value. dates Is a…

 324 total views,  10 views today

Read More...

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, with a different text string. SYNTAX REPLACE(<old_text>, <start_num>, <num_chars>, <new_text>)…

 261 total views,  1 views today

Read More...

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, and instead of querying and loading values for new column…

 403 total views,  1 views today

Read More...

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 evaluation of a PATH function. Positions are counted from left…

 89 total views

Read More...

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 PATH result, including the specified item. SYNTAX PATHLENGTH(<path>) Path Is…

 151 total views

Read More...

PATH Function DAX


Path function is a Power BI Parent and Child Functions in DAX, which returns a delimited text string with the identifiers of all the parents of the current identifier, starting with the oldest and continuing…

 365 total views,  1 views today

Read More...

EOMONTH Function DAX


EOMONTH function is a Power BI Date and time function in DAX which returns the date in datetime format of the last day of the month, before or after a specified number of months. It…

 267 total views,  3 views today

Read More...

REPT Function DAX


REPT functions is a Power BI text function in DAX which repeats text a given number of times. SYNTAX REPT(<text>, <num_times>) text is the text that you want to repeat. num_times is a number which…

 88 total views

Read More...

Rename a Dataset in Power BI Service


Power BI allows you to rename a datasets in Power BI service. You can rename the dataset in workspace, if you are either a report author or creator of workspace. First login to Power BI…

 205 total views

Read More...

SAMEPERIODLASTYEAR Function DAX


SAMEPERIODLASTYEAR is a Power BI time intelligence function in DAX which returns a table that contains a column of dates in the current selection of previous year. It is specific to a year interval and…

 737 total views,  5 views today

Read More...