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.