Forum Discussion

Freddus's avatar
Freddus
Regular Visitor
9 years ago
Solved

Need help presenting a comparable Line graph with 4 different lines

Hi,    I need help to create a Line Graph with four different report (4 sheets). I have done a appended query so the 4 sheets are combined. However, each report have different date periods so the l...
Need Help
  • cs_skit's avatar
    cs_skit
    9 years ago

    there is multiples solutions 

    you could combine the 4 tables by this:

     

    Modeling - New Table

     

    Merged4Books = UNION
    (
    TOPN(30;Table1;Table1[Date];DESC);

    TOPN(30;Table2;Table2[Date];DESC);

    TOPN(30;Table3;Table3[Date];DESC);

    TOPN(30;Table4;Table4[Date];DESC);

    )

     

    or alternatively you can add sorted index by date to the source and then join on that so the most current date is 1 the day before 2 and so on

    theres other possibibilities but for that I would need to see the data

Freddus's avatar
Freddus
Regular Visitor
9 years ago

Never mind. Got it to work. 

 

Thanks for the help, I appreciate it. 

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
9 years ago

Hi Freddus,

 

Have you achieved the original requirement? If so, would you please kindly mark the corresponding reply as an answer or share your solution so that it can benefit more people? 

 

Regards,
Yuliana Gu