Forum Discussion

josevaras's avatar
josevaras
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago
Solved

Relationship Date Table

Hello - thanks in advance.   I have two products table with product information. One is Product Sales Actuals and the other is for Product Sales Forecast. Both tables have a Reporting Weeks colum...
Tutorial Requests
  • v-xuding-msft's avatar
    v-xuding-msft
    6 years ago

    Hi josevaras ,

    Can you please share a few photos about the sample data and your expected results? Those will make us understand clearly about your requirement.

     

    How to Get Your Question Answered Quickly

     

    Best Regards,

    Xue Ding

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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

When you created a reporting week table. I have created a normal date table and used all dates that cover both tables. Or just taken distinct from one table.

Share some sample data and expected outcome. The data should able to show issues you are facing.