Forum Discussion
Solved
Missing Codes
Hello Thank you for your time. I have an issue and would really appreciate your input. I have two table 1) Budget data 2) P&L data The relationship is on the codes .i.e 1001, 1002 My issue...
Hi Adavin
Can you try creating calculated table
Dim Code =
DISTINCT(UNION(
SELECTCOLUMNS(
'Budget Finanancials Live 24-25 (24-25)',
"Code",'Budget Finanancials Live 24-25 (24-25)'[Detail Code]),
SELECTCOLUMNS(
'P&L',"Code",
'P&L'[Group1_Code])))
Create relationship between Dim Code table to Budget and P&L table with one to many relationship
Hi Adavin
Can you try creating calculated table
Dim Code =
DISTINCT(UNION(
SELECTCOLUMNS(
'Budget Finanancials Live 24-25 (24-25)',
"Code",'Budget Finanancials Live 24-25 (24-25)'[Detail Code]),
SELECTCOLUMNS(
'P&L',"Code",
'P&L'[Group1_Code])))
Create relationship between Dim Code table to Budget and P&L table with one to many relationship