Merge information from two tables (sum per day)

[qwertzuiop]

Hello my dear Power BI Community,

At the moment I have been spending a lot of time to solve the following problem and so I decided to go for help.

Considering that I am still quite new to Power BI, it can be easy for you to solve the problem - but would do me a huge favor.

Now let me describe the problem in more detail:

I use the following two tables from different information sources:

The aim is to compare the sum of the two tables calculated on the day.

• ExportPushLog -> sum of push notifications
• ExportSendings -> sum of sendings

The calculated measure as sum per day is correct for both tables as shown in the figure below.

If I pack this information into one table, then the total sum is displayed as you can see in the next figure (here for transmissions).

Do you know what I'm doing wrong. Sure, the source of the problem is the date, which is listed separately in both tables, but how can this information be summarized?

Thank you very much for your contribution.

qwertzuiop 

[Mariusz · Accepted solution]

Hi @qwertzuiop 

What you are missing is a data dimension/calendar table, please see the article below for the version of it.

https://community.powerbi.com/t5/Community-Blog/Relative-Date-Dimension/ba-p/779039

Once you have this table in your model you create a relationship between date dimension and other tables using dates like below.

Later use date from your date dimension/calendar table in your visuals.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.

[Anonymous]

@qwertzuiop Please create calculated column 

Column = LOOKUPVALUE(ExportSending[Sendings],ExportSending[Datum],ExportPushLog[Datum])

Or else you can create relationship between two tables