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

     

     

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