Forum Discussion
naifAhmedB
Helper II
Helper IIhow to create relationship with date table?
Hi I need help in this relastionship I have hourly data and i related it to the date table as in the photo however when i select a data I don't see correct numbers can you ple...
Hi naifAhmedB ,
I agree to amitchandak 's suggestion. Maybe you should create a date column in "Hourly" table.
Column = DATEVALUE([Date])Result:Hope that's what you were looking for.
Best Regards,
Yuna
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi naifAhmedB ,
I agree to amitchandak 's suggestion. Maybe you should create a date column in "Hourly" table.
Column = DATEVALUE([Date])Result:
Hope that's what you were looking for.
Best Regards,
Yuna
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.