Let’s rename the latest calculated line so you’re able to EditionID. You could potentially rename people column from the bicupid buluÅŸma twice-clicking they, otherwise because of the best-pressing the fresh column and you may opting for Rename Line. Whenever accomplished, the latest Machines dining table within the Fuel Pivot looks like next monitor.
The Machines desk is prepared. Second why don’t we perform a computed line inside the Medals that fits the latest structure of the EditionID line i established in Computers, therefore we can create a relationship between the two.
Begin by undertaking a different line regarding the Medals table, including we performed to possess Computers. Inside Fuel Rotate discover Medals table, and click Construction > Columns > Incorporate. Notice that Put Column is selected. It has an equivalent feeling once the merely shopping for Create Line.
I created the EditionID column to act due to the fact Computers desk no. 1 secret (book, non-regular field), and written an enthusiastic EditionID line regarding Medals table make it possible for organization out-of a romance between them
The fresh new Version column for the Medals enjoys a different structure compared to the Edition column within the Servers. In advance of i combine, otherwise concatenate, the Model column into the Year column to help make the new EditionID column, we have to perform an intermediary occupation one to will get Release for the best style. On formula bar over the dining table, method of the next DAX algorithm.
When you end strengthening new formula, drive Enter. Thinking try inhabited for all the rows throughout the calculated line, according to research by the algorithm you registered. For folks who compare which column towards Edition line inside Servers, you will see these particular articles have the same structure.
After you written a separate column, Power Rotate additional various other placeholder line titled Create Column. 2nd we want to produce the EditionID computed line, very look for Add Column. Throughout the formula bar, sort of next DAX formula and you will press Enter.
Observe of a lot beliefs is constant on the Medals table EditionID field. That’s okay and you will questioned, because while in the for every version of your own Olympics (today represented because of the EditionID value) of many medals had been given. What is novel regarding the Medals desk was for each and every issued medal. The unique identifier each listing regarding the Medals desk, and its own appointed number 1 secret, is the MedalKey field.
Regarding the Power Rotate windows, see Household > Glance at > Drawing Consider on the ribbon. You’ll be able to button between Grid examine and Drawing take a look at having fun with the fresh new keys in the bottom of your own PowerView window, because shown in the pursuing the display screen.
Grow Machines so you can see each one of the industries. Electricity Rotate provides a see element on bend, in order to lookup your computer data Model getting corresponding fields. Next screen reveals the newest Look for Metadata windows, with EditionID inserted from the See Just what community.
Drag brand new EditionID line for the Medals towards the EditionID line into the Hosts. Electricity Rotate produces a romance amongst the tables based on the EditionID line, and brings a line between them articles, showing the connection.
Within this section, you discovered yet another technique for incorporating the fresh new columns, composed a determined column having fun with DAX, and put one to line to establish a different matchmaking ranging from dining tables. The Computers dining table has grown to become utilized in the details Model, and its info is open to the brand new PivotTable inside Sheet1. You may make use of the relevant data which will make even more PivotTables, PivotCharts, Electricity See accounts, and a lot more.
Perform a hierarchy
Most Data Patterns were data that’s naturally hierarchicalmon these include diary analysis, geographic studies, and tool groups. Carrying out hierarchies in this Stamina Pivot excellent as you may drag you to definitely item in order to a research – the fresh ladder – instead of having to assemble and you will acquisition an equivalent areas more as well as.