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