Forum Discussion

konradjonsson's avatar
konradjonsson
Helper II
7 years ago
Solved

How to create a table and exclude certain row values?

I want to create a new table that include a) all SERIAL NUMBERS (unique) and b) the DATE when the serial number was first invoiced. (this is to later on cross-reference this date with all subsequent...
Need Help
  • TomMartens's avatar
    TomMartens
    7 years ago

    Hey,

     

    I do not fully understand ,,, but nevertheless maybe a simple DISTINCT around the SELECTCOLUMNS from my 1st answer is all you need, to bend the table to your will, like so:

    DISTINCT(
    SELECTCOLUMNS(
    ....
    )
)

    Regards,

    Tom

HotChilli's avatar
HotChilli
Community Champion
7 years ago

Create a table by filtering the first

TableX = FILTER(Table1, Table1[OrderCategory] = 2)
konradjonsson's avatar
konradjonsson
Helper II
7 years ago

Thank you.

However not what I was looking for. Perhaps my description was bit vague.