-1

i have two tables in power bi that i am trying to join or lookup. the period table has the days, months, and month id. the data table has the days and data. i need to pull the month id from the period table into the data table so that i have a table like the final result picture where the month id is now included.

period table data table

final result

i tried using lookup and crossjoin but they dont work.

David Browne - Microsoft
  • 80,331
  • 6
  • 39
  • 67
Yashvi
  • 1
  • 3

1 Answers1

0
Month = EVALUATE
ADDCOLUMNS (
    Sales,
    "month", RELATED ( 'period'[day] )
)
Tyler2P
  • 2,324
  • 26
  • 22
  • 31
Ashton
  • 1
  • 1
    Your answer could be improved by adding more information on what the code does and how it helps the OP. – Tyler2P Feb 02 '23 at 16:38