Need DAX Query

To extract values from a column in Power BI using DAX, you can use the LEFT and FIND functions. Here's an example DAX query that extracts the values before the "#" character:

NewColumn = LEFT('TableName'[ColumnName], FIND("#", 'TableName'[ColumnName]) - 1)

In this query, replace 'TableName' with the name of your table and 'ColumnName' with the name of the column containing the values you want to extract.

Similarly, if you want to extract values before the "*" character, you can modify the query as follows:

NewColumn = LEFT('TableName'[ColumnName], FIND("*", 'TableName'[ColumnName]) - 1)

To create a new column with the extracted values, simply add the above DAX query to the formula bar in Power BI and press Enter. The new column will be created with the extracted values.

Remember to adjust the query based on the specific character you want to extract values before. Additionally, you can modify the query further to handle different scenarios or patterns in your data.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Jayraj Chhaya2y ago
Accepted answer
To extract values from a column in Power BI using DAX, you can use the LEFT and FIND functions. Here's an example DAX query that extracts the values before the "#" character:
```
NewColumn = LEFT('TableName'[ColumnName], FIND("#", 'TableName'[ColumnName]) - 1)
```
In this query, replace 'TableName' with the name of your table and 'ColumnName' with the name of the column containing the values you want to extract.

Similarly, if you want to extract values before the "*" character, you can modify the query as follows:
```
NewColumn = LEFT('TableName'[ColumnName], FIND("*", 'TableName'[ColumnName]) - 1)
```
To create a new column with the extracted values, simply add the above DAX query to the formula bar in Power BI and press Enter. The new column will be created with the extracted values.

Remember to adjust the query based on the specific character you want to extract values before. Additionally, you can modify the query further to handle different scenarios or patterns in your data.