Forum Discussion
Solved
Filtering by date and Text
Hello Experts, With SUMMARIZECOLUMNS wants to create a new table. There are two columns that would be used for filtering. One text column and one date column. The filter context is all text that sta...
- Certified List =SUMMARIZECOLUMNS('Table1'[Col1],'Table1'[Col2],'Table1'[Col3],FILTER('Table1',LEFT('Table1'[col1],9)="Certified"))
koorosh , Try like
SUMMARIZECOLUMNS (
'Table1'[Col1],
'Table1'[Col2],
'Table1'[Col3],
FILTER (
'Table1',
[Col1]
IN { "Certified", " " } || isblank('Table1'[Col1]) ))