Power BI Desktop is a Tool to build Power Bi Reports, Power BI is a business analytics service by Microsoft. It provides interactive visualizations and business intelligence capabilities with an interface simple enough for end users to create their own reports and dashboards.
Power Query allows you to split a column with various options, one of them is split columns by positions which split a text columns at specific positions within a given text value. Lets see how…
86 total views, 16 views today
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…
150 total views, 16 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>)…
200 total views, 2 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…
260 total views
Pivot column is a feature available in Power Query which allows you turn rows to columns. Basically, Power Query groups each unique values and performs an aggregation that you specify such as sum, max, min,…
282 total views
PATHREVERSE 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 backwards from…
68 total views, 4 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…
53 total views, 1 views today
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…
113 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…
308 total views
When you perform sorting on months name, you will see that months name are sorted alphabetically as text, strings are sorted alphabetically by default. While you expect to see months name to be sorted chronologically….
304 total views
A Heat map is used to visualize the density of data using colors where highest data value is displayed through dark heated color, and same color turns in light color for lowest values. In Power…
180 total views, 2 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…
47 total views, 2 views today
Power BI August 2020 update has released a new feature Import text using examples, which allows you to import text/csv file which allows you to specify sample output values for the data you would like…
203 total views, 1 views today
In Power BI service a workspaces are places to collaborate with colleagues to create collections of dashboards, reports, datasets, and paginated reports. You can add users who can access, edit, and read the content in…
315 total views, 2 views today
Recently Power BI has released November 2020 update, in this update one of the coolest feature is that now you can add a zoom sliders to cartesian charts (chart which includes horizontal and vertical axes)…
318 total views, 4 views today
Sometime you are required to create a relationship between tables when both tables are having a duplicate values. In this case, If you try to create a relationship, Power BI suggest a many to many…
49 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…
252 total views, 1 views today
In Power BI there are two DAX functions that you can use to generate a date series that is CALENDAR and CALENDARAUTO. The CALENDAR function requires two input parameters that is start date, and end…
194 total views, 10 views today
TOPN function is a Power BI table manipulation function in DAX which returns the top n records from table. If you specify the number 0 to TOPN function or any less number then TOPN returns…
123 total views, 1 views today
Filter is a Power BI filter functions in DAX which returns a table that represents a subset of another table or expression. It filter the table under current filter context. It returns the table that…
48 total views