Forum Discussion
Sellout data
Hi!
I need help please. I am new using DAX.
I have a sellout table per week. As more sales weeks appear, through power query I cross the data and bring the objectives of another table (1: focus product, 0 no focus) in this way I get the data segmenter in excel to be able to filter directly from the sellout table. However, I would like to be able to synthesize all those weeks with the objectives in just one column. Is this possible? The image below show the targets in the weeks...any way just i need one colum with this target.... 😞
2 Replies
- kentyler
Solution Sage
In the query editor in Power BI you can "un-pivot" your columns so that you end up with just one column of data. This will add a value with the week name to label each of the unpivoted values.
- kentyler
If you paste some of your data from excel into a reply (instead of using an image) I will be glad to do a sample for you.
I learn something every time I answer a question
