Forum Discussion

bamba98's avatar
bamba98
Helper I
5 years ago
Solved

Select single cell from table to another table

Hi,   I have a messy file that i download every quarter. However, that download looks the same every quarter and I would like to upload that file in power bi and create a new table from the current...
DAX
Table
  • quantumudit's avatar
    quantumudit
    5 years ago

    bamba98  So, you want that in another table? Not as a column in the same table?

     

    Ok, try this one:

     

    Period =
    VAR Tab =

    FILTER(
    ALL('Table'[Column1]),
    CONTAINSSTRING('Table'[Column1],"Q1") ||
    CONTAINSSTRING('Table'[Column1],"Q2") ||
    CONTAINSSTRING('Table'[Column1],"Q3") ||
    CONTAINSSTRING('Table'[Column1],"Q4")
    )

    RETURN
    LOOKUPVALUE('Table'[Column1],'Table'[Column1],Tab)

     

    This will work when you want the "Period" as a calculated column. It should work if I have understood your requirements correctly. Worked in my case.

bamba98's avatar
bamba98
Helper I
5 years ago

quantumudit yes correct. I have a table that contains a column. In that column there is only one cell specifying the period. I want to extract that single cell into a column in another table

quantumudit's avatar
quantumudit
Super User
5 years ago

bamba98  So, you want that in another table? Not as a column in the same table?

 

Ok, try this one:

 

Period =
VAR Tab =

FILTER(
ALL('Table'[Column1]),
CONTAINSSTRING('Table'[Column1],"Q1") ||
CONTAINSSTRING('Table'[Column1],"Q2") ||
CONTAINSSTRING('Table'[Column1],"Q3") ||
CONTAINSSTRING('Table'[Column1],"Q4")
)

RETURN
LOOKUPVALUE('Table'[Column1],'Table'[Column1],Tab)

 

This will work when you want the "Period" as a calculated column. It should work if I have understood your requirements correctly. Worked in my case.