Forum Discussion
Id based on multiple columns
Hello, I need an id based on three different columns with text. Right now the way that I am doing this is by concatenating all three columns together using the DAX below and it is working fine. ...
Can you tell us why you need the unique id.
I want to have three filters, f1, f2, and f3, such that f1 filters f2 and f3, f2 filters f3 and all of them filter data from two different data tables.
In order to get these filters to work, I created a new table that has a one to many relationship with the two data tables via the factorid.