How to cut columns and paste under Other columns in Power qury

[Anonymous]

Hello All,

I am beginner to powerBI...when working on one of my data ..i faceing an issue...in my  data set i have all 12 months of data side by side ..so i want bring them one below the other ..to have single table with only one date column  ..please find below data set...i tried of doing creating 12 duplicates for 12 month and later merge all duplicates its very time taking process(i even need do this task other simmilar data ) ...please can any one suggest that how can we create a table using DAX...by selecting fixed range of columns ands pasting one below the Other or any other best possible solution

[v-juanli-msft]

Hi 

Is this problem sloved? 

If it is sloved, could you kindly accept it as a solution to close this case and help the other members find it more quickly?

If not, please feel free to let me know.

Best Regards

Maggie

[v-juanli-msft]

Hi @Anonymous 

You could find the "append" feature in the link provided by amitchandak,

name the date column and other columns for every month with the same name, then append them,

then you will get a table with date column and other columns.

date column holds dates from Jan to Dec.

After loading data into data model, you can create a date table and create relationship between this date table and your main tables.

how can we create a table using DAX...by selecting fixed range of columns ands pasting one below the Other or any other best possible solution

Is this your expected output?

If so, please use date hierarchy in matrix.

https://5minutebi.com/2017/11/29/how-to-use-powerbi-date-hierarchy/

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , see if this can help

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

https://www.poweredsolutions.co/2019/07/30/grouping-rows-with-power-bi-power-query/