Forum Discussion
Combine month only data with daily data
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!
Memorable MemberHi 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!