Using Multiple Data sets to create metrics trend

[k_Saurabh]

Hi All,

Due to the huge dataset, I have ceated monthly data sets and created a report  for each month.

Now, I need to show some monthly trends for which I need atleast 6 month of data in one data set. So I was thinking if there is a way so that I can merge monthly dataset and create a new 6 month data set to show monthly trends.

Or in case there is another better idea to show the trending using 6 diplz suggest so.

Thanks in advance!!

Regards,

Saurabh

[Anonymous]

@k_Saurabh 

If you have same columns in each month table, can you just append the 6 months table as a new query in query editor?

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@k_Saurabh , Create a date table(or month table) , join with all tables and sum up the measure from all these tables and use that in visual (other common dims needed too)

= [Measure month1] + [Measure month2] + [Measure month2] +Measure month3] + [Measure month4] + [Measure month5]