Forum Discussion
SQL Query or Remove Columns
Hello, I've got a question that I haven't been able to figure out on my own, Using PBI Desktop, asfter selecting a data source, you're given the option in Advanced Options to write an SQL stateme...
Hi ThisIsFrank,
>> If I choose to Remove Columns, will the removed columns still be queried, but just not displayed in the dataset?
I think the columns will be removed from query, but the query editor has stored the applied steps. You can cancel this step to recover this column.
>> If so, what is the equivalent to a WHERE statement in Query Editor? Some sort of DAX measure?
In query editor, WHERE statement is equivalent to 'FilteredRows' or ‘SelectedRows’; In dax measure, it same as filter function.
In summary, if you operate the data on query editor, it directly operate on the query, but in Dax formula, it use the filter to hide/display specify records.
Reference:
Regards,
Xiaoxin Sheng