Forum Discussion
TY and LY
Hi there,
have a question for the forum :).
I have two datasets, same column but one includes data for year 2017 and the other one for 2018. How can i make a column or a formula that skews LY and TY data. I've tried to append them together then filtering Ly and TY into 2 separates queries but it makes a lot of distorsion by the generation of many blank fields that i can't clean.
any ideas?
thank you
Alberto
6 Replies
- Yggdrasill
Responsive Resident
If the columns are exactly the same between the datasets then the append should work just fine.
You can clean your data in Query Editor by filtering out rows and values you don't want in your final appended dataset.
Classic error is that one dataset has a string value in a columnt that is solely formatted as numerical so watch out for mismatch in column formatting
Hi Yggdrasill,
din't work, it returns with an incredible amount of blank rows which can't be removed when filters are activated in report.
So it has to be made referring to the same period taken as a day or a month (by purchase date) for example.
- Yggdrasill
In Query Editor (Edit Queries) , choose your main column, click the arrow down and tick "Remove empty"
Like so
- MFelix
Super User
Hi Anonymous,
Not sure how you have your setup you can do it in the query editor and then cleaning it up.
Other way is to create a new table in the front end with the following syntax:
Table = UNION(ALL(Table1[YEAR];Table1[Value]);ALL(Table2[YEAR];Table2[Value]))
With the ALL functions you are only selecting the columns you need for each table.
Regards,
MFelix
