Duplicate columns with different filter

[Anonymous]

Hi,

I'm trying to duplicate a column and then apply individual filters.

This doesn't seem possible at the moment as filtering any one of the duplicate columns filters all the duplicate columns.

Is there a way that I can perhaps copy teh data from one column to a new column with this not breaking the link of data back to my SQL database? 

I don't really wish to alter my SQL table directly, but is this the only real way to seperate out this data (without having to constanlty apply DAX filtering on each page/report/visual)?

Thanks,

James

[mahoneypat]

Not sure I understand your scenario, but you could "Reference" your original query (right click on it in query editor and choose Reference), remove all the columns except the one you plan to filter, and then filter it.  You could then use that filtered column in slicers, your model, etc.  Is that what you need?

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[Anonymous]

@mahoneypat thanks for the help

I have just found Referencing... the only issue is this adds a column to a new table not an existing table. It also doesn't like the referencing loop caused by trying to create a column that references a column from the same table.

Essentially, I have both string values and numeric in my column. I need to seperate these out as numeric values column and string column. From there, the string column values are each a composite of 3 seperate numeric values with a delimeter joining them and they will then be split with this delimeter.

EG) seperate values of 2    7    5    6 as well as "2342-234234-234" are in the same column with the - (dash) being a delimeter for spliting later.

I want all these sets of numeric values as seperate columns in the same table, meaning there will need to be four columns as a result, not just one (the numeric values and then the three numeric values that result from the delimeter split).

So, I need to have duplicate columns in the same table (that act like reference columns) so that I can first filter out the one column with the delimeter values (which will then be split) and the other (perhaps the origional column) to filter without the delimeter values.

I'm not sure i'm going abou tthis the right way, but i would prefer to have the process done in the "Transform"/Power Query side of things. But ultimately I just want the values to show up in the "Fields" data source area as seperate values I can drag and drop as seperate values/columns.

I hope this made sense.

[Anonymous]

It's just occurred to me that I won't be able to split a referenced column either as i'm using Direct Query... hopefully I can get around that with a further duplication of the column (and hiding the origional).

[Anonymous]

Never mind. I've worked out you can't do any real sort of column manipulation with Direct Query. I'm use to Imported data.

Thanks anyway