Relationships in power Bi. Two tables with no unique ID

[funktheory277]

Hi, so im really struggling with relationships. I have one set of data that goes from January to May then another from June ongoing. How do i connect the relationships and then display in a visual, in laymans terms?
I have used power BI for years but this has always been my stumbling block. Thank you

[andrezmar]

Hola funktheory277. Si los datos de Enero a Mayo y los datos de Junio en Adelante son los mismos, pero de periodos diferentes, te recomiendo que en Power Query realices el proceso de Anexar Consultas. A partir de dos consultas, las une y queda solo una.

A la consulta que queda, te recomiendo que le relaciones una tabla calendario.

[funktheory277]

Hi, yes i could but i would rather learn about why they arent linking ?

[Greg_Deckler]

@funktheory277 Can you post some sample/example data? Should be able to form a relationship even if it is many-to-many.

[Greg_Deckler]

@funktheory277 Can you just append the two queries in Power Query Editor or use UNION (DAX)?