Forum Discussion
make two relations for two table HELP
Hey, I have two tables, one is an alarmlist with a specific system message for an alarm, and the other is a table with all alarms that have been triggered, what alarm, time and duration and for ...
Combine your columns in M or DAX
M: Table.AddColumn(alarmlist, "FullID", Text.Combine({Text.From("AlarmID"),Text.From("MachineID")})
DAX: alarmlist[FullID] = "" & [AlarmID] & [MachineID]
Do this for both tables and create your relationship between the 2 [FullID] columns, which should have be many-to-one events-to-alarmlist
Events that do not have a corresponding alarmlist entry (like when alarm ID = 0) will show up as (Blank) error codes
Anonymous ,
There is two way. One is to append data - https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Another one is to create common dimensions using union and distinct and join them with these tables
machine = distinct(union(all(table1[machine Id]),all(table2[machine Id])))
Do same for other dimesnions