Forum Discussion
How to create a table and exclude certain row values?
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
Thanks Tom!
It is definitely one step in the right direction. There is one more requirement that I did not specify clearly in my initial question - there can be only one row per serial number, i.e. the table should have no duplicates.
The reason that the current table have duplicates is that the original table include several rows with the same serial number (these rows are different order line items).
So, I would need an addition to the DAX-function that only keeps one row per unique serial number.
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
Yes, now it did solve the problem!
Brilliant - thanks a lot!
/Konrad