Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.... 😞
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
I'm a personal Power BI trainer
Help when you know. Ask when you don't!
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.
Help when you know. Ask when you don't!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
46 | |
28 | |
22 | |
12 | |
8 |
User | Count |
---|---|
75 | |
52 | |
46 | |
15 | |
12 |