Table.FindText in power query

What is Table.FindText in Power Query and How Do We Use It?

Table.FindText is a Power Query function in Power BI that returns the rows in a table that contain specific text. If the text is not found in the table, then an empty table is returned. Syntax Table.FindText has simple syntax and can be written as the below. Table.FindText(table as table, text as text) as table…

How to Use COMBINEVALUES function in DAX

How to Use COMBINEVALUES function in DAX

If you want to combine multiple values in DAX, the COMBINEVALUES function is what you need. This function concatenates a list of strings separated by a delimiter. The result is a single string. • String1: The first string that you want to concatenate.• String2: The second string that you want to concatenate.• Additional strings that…

Future of Power BI

How Power BI will change the way we interact with data in future?

In recent years, data visualization has become increasingly popular to help people make sense of large amounts of data. Power BI is a tool that allows users to create beautiful visualizations of their data. It is also interactive, allowing users to drill down into the data to see more detailed information. Power BI will change…

Parallel Period in Power BI
|

How to Use PARALLELPERIOD In Power BI

PARALLELPERIOD is a DAX function that returns a table that contains a series of dates parallel to the dates to the function. This function can be used to calculate numeric columns over a given timeframe and supports monthly, yearly, and quarterly intervals. PARALLELPERIOD Syntax The DAX syntax for PARALLELPERIOD is simple and can be seen…