Forum Discussion
Solved
Filter just values in the column and not the row context
I'm trying to filter a table based on a designation of if the sales were core sales or not by item. The item designation changes based on the date it was ordered so Item2 could be a Core item or Clos...
Best option would be to unpivot your data to bring it into a usable format.
Second best option is to add a column that checks if Designation1 or Designation2 is "Core". Then filter by that column.
lbendlin
Super User
Super UserBest option would be to unpivot your data to bring it into a usable format.
Second best option is to add a column that checks if Designation1 or Designation2 is "Core". Then filter by that column.
Unfortunately I'm Direct-Querying into this data so custom columns and unpivoting the data is not in the cards.
- lbendlin
Custom columns are supported in Direct Query mode. They are expensive, but they are supported.
Yeah I have it but my data set is over 1,000,000 records and so I get an error saying I've maxed out the number of records allowed to review.
