CONCATENATEX Function DAX
CONCATENATEX function is a Power Bi text function in DAX, which evaluates expression for each row on the table, then return the concatenation of those values in a single string result, separated by the specified delimiter
Home » Archives for Pradeep Raturi »
Pradeep Raturi
I have 11+ years of working experience in Business Intelligence Data Modelling, Power BI, SQL Server, SSRS, SSIS, Azure Data Factory, Power Apps.
Create Index column using a Power Query
Create Index column using a Power Query in Power Bi
Using a Power Query, you can add index column to your data that serves as a row counter to rows in data table, it is really a best feature of power query.
SUMMARIZECOLUMNS Functon DAX
SUMMARIZECOLUMNS function is a Power Bi Table Manipulation function in DAX which returns a summary table over a set of groups.
VALUES function DAX
VALUES function is a Power Bi table manipulation function in DAX which removes duplicate values and return unique values. A blank values can be added.
Create a SSRS Matrix Report
A SSRS Matrix report is very similar to a Tabular report, but it displays a data grouped by columns and rows, with aggregate data at the intersections. It is similar like a SQL Pivot to transform data from row-level to columnar data .
Report ToolTip page in Power BI
Power Bi allows us to create a report tooltip pages, means you can access a report page inside tooltip.
So for any selected records on visuals you can display more information by displaying a report page as a tooltip.
SUBSTITUE Function DAX
SUBSTITUE Function DAX
SUBSTITUE function is a Power BI DAX TEXT function that allows to replace existing text with new text in a text string.
Publish Report to Power BI Service
When you create a report in Power Bi desktop, and you want to share the report with end-users then you can publish the report to Power Bi services.
Personalize Visuals Preview Power BI
Power Bi introduced a Personalize Visuals Preview features in May 2020 updates. When Personalize Visuals Preview feature is enabled for report then end-user can explore and personalize the visuals within report.
Unichar function DAX
UNICHAR function is a power BI DAX text function that returns Unicode character referenced by the numeric value.
Dynamic Page Navigation using slicer in Power BI
Implemention of Dynamic Page Navigation using Slicer in Power Bi
SUMMARIZE Function DAX
The SUMMARIZE function is a Power Bi table manipulation function in DAX that allows you to create a customised table directly in Power BI, without using Power Query.
SQL Server Cursor
A SQL cursor is a database object that is used to retrieve data from a result set one row at a time. A SQL cursor is used when the data needs to be updated row by row.