Combining/grouping several dates together

Question

I'm trying to combine multiple date columns into a single column so I won't have to have several date columns but instead only one. What would the best way be to accomplish this?

Using the query editor? Calculated columns? Measures? I'm a bit lost right now, any help would be appreciated!

See pictures below!

Table1:

Table2:

Matrix: I've added all dates in this matrix in the picture below, so instead of having them split like this I'd like to have them all grouped together by year and month. Is it possible to accomplish?

v-sihou-msft · Answer

HenkeC
&nbsp;
In this scenario, you should separate your first dataset into two datasets, each contains ID, Date, Amount columns only. Then append all three datasets together.
&nbsp;