Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 ...
Need Help
  • hansei's avatar
    hansei
    6 years ago

    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

hansei's avatar
hansei
Helper V
6 years ago

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