Forum Discussion

Dvilches_'s avatar
Dvilches_
Frequent Visitor
6 years ago

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's avatar
    kentyler
    Solution Sage
    6 years ago

    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.