Forum Discussion

rima_ch's avatar
rima_ch
Frequent Visitor
3 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 Depa...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 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]
)
Jihwan_Kim's avatar
Jihwan_Kim
Super User
3 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
    3 years ago

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