Assistance with Merging some Datasets into a single visual

[PrivateAnalytic]

Hello! This may not be possible in any way whatsoever. But I figured it'd be nice to reach out.

Scenario: I have 2 datasets encompassing the same kinds of data (2 different sources). 1 of the sources is valid for the first half of the year, the 2nd source is valid for the second half of the year. They essentially show the same data and I can create the same visuals for them, but I want to try to consolidate the 2 into 1 for simplicity reasons. Is there a way in Power BI I could do this? They are different column names so I want to rule out Appending in the transform data section. Maybe a DAX measure? But I feel that could be too complex. Any thoughts? 

For reference, this is the visual I am trying to make into 1.

[Idrissshatila]

Hello @PrivateAnalytic ,

so if you want to use dax to do so, you could use the union dax function.

check this video for instructions https://youtu.be/yhKZtaYPCts

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[Syk]

More detail on what your tables actually are would be more helpful but if it's the same data, appending would be the answer. Just rename the columns so they line up and append. If there's more nuance than that - post some details of the tables.

[PrivateAnalytic]

@Syk 

The former dataset is set up as follows:

visitor

personid

enterdate

offer

offerid

offerdate

The current dataset is set up as follows:

preofferid

offerid

offerdate

offer