Get value from cell based on its row and column combination

Question

Hey guysI’d much appreciate your help on this, as I’m new on PowerBI.&nbsp;I’d like to have the option to compare the same two metrics depending on the column combination. I have created a very simple example in excel…&nbsp;&nbsp;So basically, I want to obtain for each area (row) the value from “season 1.value Y”, and also get the value from “season 2.Value Y” and be able to later compare them with a visualization that allows me to set a target and an actual value, being in this case my target “season 1.value Y” and my actual “season 2.Value Y”&nbsp;Value Y es one value, the same that repeats depending on the season.&nbsp;Is it possible to get&nbsp;the value from a particular "cell" and then use it later? Let me know if you need further clarification!Thanks!!!

greg_deckler · Answer

So, what you want to do is get your data in a format like this:

Area,Season,Value X,ValueY

area1,season1,1,1

area1,season2,3,2

area2,season1,2,2

area2,season2,2,3

area3,season1,1,1

area3,season2,1,2

rsomoza · Answer

Hi smoupre&nbsp;Yes I need a way to get the values based on the season and the area. So I can compare, for example the value Y result "1" from the first row with the value Y restult "2" from the second row...and later use the value to compare or visualize if the second one is higher, lower or same....&nbsp;row1: area1,season1,1,1row2:&nbsp; area1,season2,3,2&nbsp;:) Is there a way?

rsomoza · Answer

&nbsp;&nbsp;Any ideas? is it possible to handle values like this in Power BI??&nbsp;Cheers!!

michiel · Answer

What smoupre means is to start with loading data in a tabular form. So make sure you have a table with columns Area, Season, ValueX, and ValueY (see his example); or even with columns Area, Season, X/Y, and Value. When you do this, you can create reports with e.g. a table with Area and ValueY, and Power BI will aggregate the ValueY values by area:&nbsp;Area, &nbsp; Sum of ValueYarea1&nbsp; 3area2&nbsp; 5area3&nbsp; 3&nbsp;When your data is in a different format, the Power BI Get Data experience (Power Query) can transform it into the format you need.&nbsp;

rsomoza · Answer

Thanks.. but I think that maybe my goal was not properly explained.&nbsp;&nbsp;I have two seasons and I want to compare the units we sold in each of them. I do have above idea of a report in my PowerBI. Data is accurate.&nbsp;What I'd like to know if there is any way to get value 6 and separately get value 10 and compare them using a KPI vizualization. There is one&nbsp;visualization (KPI Visualization) that allows me to compare a Target and an Actual by something (season)... I want to use the Target as&nbsp;value 6 and Actual&nbsp;as value 10. I can't just use Units in the visualization because it&nbsp;is the same information for season but with different&nbsp;results.&nbsp;I know that are other tools that allow user to get and use the values using variables, but not sure if it is the case of PowerBI, or if there is any other way to handle those numbers.&nbsp;I much appreciate your help!&nbsp;

Forum Discussion

Get value from cell based on its row and column combination

7 Replies

Related content

Combine Column

Combining Column Data

Combine columns into 1

Tables combine

Combine Sum two value in one column