Forum Discussion

lua2's avatar
lua2
Frequent Visitor
3 years ago

linking two tables

Hello,  I have two tables that I want to link together, but I don't know how to do it correctly. Because in table A there are different phases per ID with a start date (start of the phase). In table...
Need Help
v-yadongf-msft's avatar
v-yadongf-msft
Community Support
3 years ago

Hi lua2 ,

 

I want to confirm the following things with you:

1. What's the relationship between date column in table A and date column in table B ?

2. What's the meaning of Ranged Date Data ?

 

In order to better understanding your demands and give the right solution, could you please share with me some screenshots of your data after hiding sensitive information and tell me what's your expected output?

 

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

lua2's avatar
lua2
Frequent Visitor
3 years ago

Hi v-yadongf-msft , 

 

This is the Visual I need: 

 

But in the visual I am now missing the column [Name] from the table Allocation. The column [Name] should then be in the rows of the matrix table under phase name.

 

Then I need the widget with which I can filter by month.

Screenshots of Tables: 

 

 

 

I have tried several ways to connect the tables, unfortunately I have not found a solution.

 

Thanks and kind regards

lua2