- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Dax for: Create a new column where Value is equal value of one row before of the left column
Hi everyone,
I have multiple tables with the structure similar as the table below. Since it has the country and the company names in the same column, I would like to create a new column ("Country") where the value takes up the volumn of column A but a row before. (examples illustrated in yellow column)
Afterwards, I can filter out the rows where "plant location" is null to get the desired table of 3 columns "Company", "plant location", "Country"
Or if anyone has any other ideas how to extract the country name and get the same results of a 3-column table, I would also very much appreciate.
Thanks!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

if you add an Index column (using the interface) you can get the value of the column in the row prior:
#"Added Index"{[Index] - 1}[Company]
edit: power query solution
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

if you add an Index column (using the interface) you can get the value of the column in the row prior:
#"Added Index"{[Index] - 1}[Company]
edit: power query solution

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
08-12-2024 10:10 PM | |||
11-07-2023 08:29 PM | |||
08-08-2024 07:49 AM | |||
12-20-2023 03:39 AM | |||
Anonymous
| 06-07-2024 06:01 AM |
User | Count |
---|---|
141 | |
110 | |
81 | |
61 | |
46 |