Forum Discussion

bamba98's avatar
bamba98
Icon for Helper I rankHelper 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.

quantumudit's avatar
quantumudit
Icon for Super User rankSuper User
5 years ago

If I am not wrong then, you got a single column with messy value and there is only one cell that contains the "Q3" string period value.

The formula will work only if the above condition is met.

bamba98's avatar
bamba98
Icon for Helper I rankHelper 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
    Icon for Super User rankSuper 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.