Dax search

[Rish2580]

Hello, I am trying  to develop a  dax query to search for data in a table. Basically the query should search for data in a table which has both integers and decimal values.  If I search "99" I should get all the records with 99 in it and if I search "99.99" I should get all the records with 99.99 (for example) can some please help me with the logic.

[Anonymous]

Hi @Rish2580 ,
Based on your description, you can use the following functions in a dax query to accomplish your goal.

Here some steps that I want to share, you can check them if they suitable for your requirement.

Here is my test data:

Create dax query

EVALUATE
FILTER(
    'Table',
    'Table'[Whole number] = 99
)

EVALUATE
FILTER(
    'Table',
    ROUND('Table'[Decimal number], 2) = 99.99
)

Final output

Best regards

Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Rish2580]

Hello Alberto, thank you for responding. The numbers I gave was just an example. Should I use INT instead of the whole number? How can I use both the conditions in the same query as I need to search for the data in same table. 

[Anonymous · Accepted solution]

Hi @Rish2580 ,
Set the format of the power bi data as shown in the figure. A column in power bi can only have one data format.

If you want to do both, you can try merging these two pieces of code

EVALUATE
FILTER(
    'Table',
	'Table'[Whole number] = 99 ||
    ROUND('Table'[Decimal number], 2) = 99.99
)

Best regards

Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly