Common values as One

[Sudharshan1919]

Hi All,

Below is my data looking like.

Table A

Machines    Date   

M1              22nd March 2023

M2              23rd March 2023

M3              24th March 2023

Table B

Resource   Date                       Cost

R1            22nd March 2023  100

R2            23rd March 2023     50

R3            24th March 2023   80

Table C

UserName           Date              

U1                  22nd March 2023

U2                  22nd March 2023

U3                  23rd March 2023

Now my requirement is All the dates must be into a separate column/seperate table and all the common dates in those tables must be into one seperate table, so that whenever i select the date from the newly created date table all the data according to that will change in the dashboard.

Expected Output:

----------------------

Date

22nd March 2023

23rd March 2023

Request your help on this.

Thanks

[Ahmedx]

plse try this