Forum Discussion
Combine Multiple Months data in Power Bi
Hi Team, I have data for years on months wise so how to combine years wise data in power BI. Please find below 2 screen shots from Power BI and Excel
Excel,
Hi Anonymous ,
According to your description, here's my solution.
1.Select the columns from 2017/1/1 to 2017/12/1, the click unpivot columns.
2.Get three columns.
3.Created a year column.
Year = YEAR('Table'[Date])4.Create a matrix visual, put Sales Person ID in rows, put Date and Year in columns and Value in values, then turn on the drill button.5.Click drill down, then get the total value by year.
I attach my sample below for reference.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- amitchandak
Super User
Anonymous , In Power bi, either use the date hierarchy, option after dragging a date in visual. Right click date hierarchy .
Or in your table or date table create month year and use that
Month Year = FORMAT([Date],"mmm-yyyy")
Month Year sort = FORMAT([Date],"yyyymm")amitchandak , i tried this way but it's not merging all the rows
v-yanjiang-msftCommunity Support
Hi Anonymous ,
According to your description, here's my solution.
1.Select the columns from 2017/1/1 to 2017/12/1, the click unpivot columns.
2.Get three columns.
3.Created a year column.
Year = YEAR('Table'[Date])4.Create a matrix visual, put Sales Person ID in rows, put Date and Year in columns and Value in values, then turn on the drill button.5.Click drill down, then get the total value by year.
I attach my sample below for reference.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
