Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I curentlly have two tables, which both contains some measurements and date this measurement was measured.
Also these tables are connected via STATION (key).
I need for the Date Picker, to affect both of the DATE fields. Either this solution, or combine these two dates to one and apply date picker to this field.
Example of my problem:
MEASURE1:
LOAD * INLINE [
Station_id,Date,measure1
1,2022-10-23,10
2,2022-10-22,20
3,2022-10-21,100
];
MEASURE2:
LOAD * INLINE [
Station_id,Datum,measure2
1,2022-10-22,3
2,2022-10-22,4
3,2022-10-22,4
];
Note: currently the dates are named diffrently.
Thank you for any help,
BR Vojtěch
This is a classic problem with temporal dimensions. You have several approaches, from using a master calendar to use a unique fact table: