Forum Discussion
Dax search
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.
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
3 Replies
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
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.
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
