Forum Discussion

Rish2580's avatar
Rish2580
New Member
2 years ago
Solved

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...
  • Anonymous's avatar
    Anonymous
    2 years ago

    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

     

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
    Rish2580
    New Member
    2 years ago

    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's avatar
      Anonymous
      Not applicable
      2 years ago

      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