Forum Discussion
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...
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
