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.
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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