Forum Discussion
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...
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 = '""') ) )
Assuming this is for a new measure within the report, I've generally solved this with a CALCULATE and double & for the AND. You could do something like:
CALCULATE(
SUM( 'Table'[Column] ),
(NOT( 'Table'[Column A] = " ") && NOT( 'Table'[Column A] = "") )
)
