Forum Discussion

GuillaumeL06's avatar
GuillaumeL06
Regular Visitor
7 years ago
Solved

New value in a column with a DAX code

Hello everyone, I have a table : Site                                      Frs                                       Code                    NAB                                    A               ...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    7 years ago

    you can try:

    CODE = 
IF(
    SEARCH("P7",
        CONCATENATEX(
            FILTER(
                'Table',
                'Table'[Frs] = EARLIER('Table'[Frs])
            ),
            'Table'[Site],",")
        ,,0),
    "Y",
"N")

    I added P3/B to test

Anonymous's avatar
Anonymous
Not applicable
7 years ago

you can try:

CODE = 
IF(
    SEARCH("P7",
        CONCATENATEX(
            FILTER(
                'Table',
                'Table'[Frs] = EARLIER('Table'[Frs])
            ),
            'Table'[Site],",")
        ,,0),
    "Y",
"N")

I added P3/B to test

  • d_gosbell's avatar
    d_gosbell
    Super User
    7 years ago

    Or if you just want the value of Code for Site="P7" and Frs="A" for every row you could do the following:

     

     

    Code2 = LOOKUPVALUE('Table'[Code],'Table'[Site],"P7",'Table'[Frs],"A")

    Although I'm not sure why you'd want this in a column it feels more like something that you'd using a measure.