add columns from different tables into one table

[alevandenes]

Hi all,

i have created a visualization in PBI Desktop that looks like this table below

The Number of occurences is coming from one table

The number of units shipped is coming from another

column in common for the two tables is the Date

i need to reproduced exactly the same overving but in a table "behind the scenes". any suggestions?

[amitchandak]

@alevandenes , You need share some table details for exact formula,

But these videos can help. refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8

[alevandenes]

Hi Amit,

Thank you for your reply.

Number of occurences: DISTINCTCOUNT(issue number) from Issues table

Number of Units shipped: SUM(units shipped) from Sales date

i have a dimensional Date table that links Creation Date of Issue to Shipment Date

[amitchandak]

@alevandenes , then you can create a measures from both tables and analyze it with common dimensions like date?

[alevandenes]

yes, i am doing that but i need to use output of these measures as input for another measure. so i thought of creating a stating table in the background. but i dont know which formulas to use to do that