Forum Discussion

rima_ch's avatar
rima_ch
Frequent Visitor
4 years ago
Solved

Dax Lookup

Hello everyone, please I need a help, I want to add a new column "Column 4" in front of each row I habe to see the value of the column Title, As you can see below I need to add the column4 "each Departme has one title", I have tried to add a column with lookupvalue (if blank) but it's not working.

 

Thank you in advance.

Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

    It is for creating a new column.

     

     

     

    Title Name CC =
SUMMARIZE (
    FILTER (
        Data,
        Data[Department] = EARLIER ( Data[Department] )
            && Data[Title] <> BLANK ()
    ),
    Data[Title]
)

2 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    4 years ago

    Hi,

    I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

    It is for creating a new column.

     

     

     

    Title Name CC =
SUMMARIZE (
    FILTER (
        Data,
        Data[Department] = EARLIER ( Data[Department] )
            && Data[Title] <> BLANK ()
    ),
    Data[Title]
)
    • rima_ch's avatar
      rima_ch
      Frequent Visitor
      4 years ago

      Thank you a lot, That's what I was looking for.