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.
The other idea that comes up is that this is usually done before loading the data into power bi, if you can access the data file and operated on it, maybe in excel, access or sql server
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.
