Forum Discussion
DataGuy2016
Advocate IV
Advocate IVDISTINCT command pulls BLANKS
Hi there, We are creating DISTINCT tables. We are getting distinct rows, but we are also getting a BLANK row. How do we remove the BLANK row so we only have non blank rows? We looked at:...
Just change the column instead of all table
Table = DISTINCT(FILTER(VALUES(Transactions[CheckInLoc]),LEN(Transactions[CheckInLoc])>0))
Vvelarde
Community Champion
Community Champion
Hi, please try with this:
Table = DISTINCT(FILTER(Transactions,LEN(Transactions[CheckInLoc])>0))
- DataGuy2016
Hi,
Nice try and thank you very much for your suggestion.
However...
I only want the CheckinLoc column with the unique values for that column. Your query pulls all columns.
- Vvelarde
Just change the column instead of all table
Table = DISTINCT(FILTER(VALUES(Transactions[CheckInLoc]),LEN(Transactions[CheckInLoc])>0))
- DataGuy2016
