Forum Discussion
Create duplicate rows for following months in Matrix
Hi. How do I get my matrix visualisation to look like the excel screenshot below?
The white cells are forecasts, orange are past sales. How do I duplicate my sales data in Power Query so that it appears for every month in the matrix? Or do I have to do it manually in excel?
3 Replies
- amitchandak
Super User
Anonymous , one way is cross join. In dax you have crossjoin that you can do with the month you do not have data. or full outer in power query
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
amitchandak sample sales data looks something like that, so dates under EDD should match the Column Headers and the dates under SupplyReqYear should match the Row Headers.
The below pic is intended PBI matrix output. So all the cells should be populated.
Sorry, i'm really a novice so a step-by-step guide would be super helpful, thank u so much.
v-henryk-mstfCommunity Support
Hi Anonymous ,
Provide correct data information according to the following blog: How to Get Your Question Answered Quickly - Microsoft Power BI Community
I will answer you as soon as possible, looking forward to your reply.
Best Regards,
Henry
