Forum Discussion

OlegV's avatar
OlegV
Helper III
2 years ago
Solved

Convert from sql to dax

Hi, In SQL server there are two strings in the where clause: '" "' (single double space double single) '""' (single double double single)   Select ... From ... Where ColumnA <> '" "' and Colum...
Need Help
  • AmiraBedh's avatar
    AmiraBedh
    2 years ago

    Here's how you can recreate your SQL WHERE clause in DAX:

    FILTER (
TableName,
NOT (ColumnA = ' " ' ) && NOT (ColumnA = '""')
)

    Or, if you are creating a measure or a calculated column, you might use an expression like this:

    MeasureName = CALCULATE (
[YourCalculation],
FILTER (
TableName,
NOT (ColumnA = ' " ' ) && NOT (ColumnA = '""')
)
)
AmiraBedh's avatar
AmiraBedh
Super User
2 years ago

Here's how you can recreate your SQL WHERE clause in DAX:

FILTER (
TableName,
NOT (ColumnA = ' " ' ) && NOT (ColumnA = '""')
)

Or, if you are creating a measure or a calculated column, you might use an expression like this:

MeasureName = CALCULATE (
[YourCalculation],
FILTER (
TableName,
NOT (ColumnA = ' " ' ) && NOT (ColumnA = '""')
)
)