Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Displaying multiple dates in a fact table?

Hi All,   Quick question about dates if anyone can help?   I have one fact table that contains 5 dates. This fact table is connected a single date table something like the below:    Logged Date...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Anonymous 

    How about changing the data model as below

    for example, original main data table

    Logged Date Shipped Date  Closed Date Created Date Updated Date sales
    1/1/2018 1/2/2018 1/3/2018 1/4/2018 1/5/2018 1.00
    1/2/2018 1/3/2018 1/4/2018 1/5/2018 1/6/2018 2.00
    1/3/2018 1/4/2018 1/5/2018 1/6/2018 1/7/2018 3.00
    1/4/2018 1/5/2018 1/6/2018 1/7/2018 1/8/2018 4.00
    1/5/2018 1/6/2018 1/7/2018 1/8/2018 1/9/2018 5.00

    after unpivoting columns

    Then create a date table and connect this date table to your main data table

    calendar date = CALENDARAUTO()

    then on the report

     

    Best Regards

    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi Anonymous 

How about changing the data model as below

for example, original main data table

Logged Date Shipped Date  Closed Date Created Date Updated Date sales
1/1/2018 1/2/2018 1/3/2018 1/4/2018 1/5/2018 1.00
1/2/2018 1/3/2018 1/4/2018 1/5/2018 1/6/2018 2.00
1/3/2018 1/4/2018 1/5/2018 1/6/2018 1/7/2018 3.00
1/4/2018 1/5/2018 1/6/2018 1/7/2018 1/8/2018 4.00
1/5/2018 1/6/2018 1/7/2018 1/8/2018 1/9/2018 5.00

after unpivoting columns

Then create a date table and connect this date table to your main data table

calendar date = CALENDARAUTO()

then on the report

 

Best Regards

Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.