Forum Discussion
Solved
Combine month only data with daily data
I'm not really sure how to describe this the best. I have to combine two data sources and then compare them YoY and QoQ, one is our historic data that will be imported as a csv file with data in mont...
Hi jakoblerche ,
I think you have two options:
1. Either create some conditional column, which would have a logic like "If contains January then put 01.01....If contains February then put 01.02.... etc"
Then you can combine your new "months" with the year from old column.
2. Create a sort of Bridge table, where you have Dates and column with old formating. So on one row you will find January 2020 and also 1.1.2020.
Let me know if it helped!
You got me thinking about it the right way, I ended up creating a new table that calculates each month from the main table based on new column that sums up year and month. Thanks!