Forum Discussion

markquisquirin's avatar
markquisquirin
Frequent Visitor
3 years ago

Adding new column based on another column criteria on the same table

Hello, I have this problem where I wanted to add a new column based on the criteria from another column on the same table.  Below is what my table looks like.  Number Link Type Party ID 5...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi markquisquirin ,

Please have a try.

Create a measure.

Measure = MAXX(FILTER(ALL('Table'),'Table'[Number]=SELECTEDVALUE('Table'[Number])),'Table'[Party ID])

Or a column.

Column = MAXX(FILTER(ALL('Table'),'Table'[Number]=EARLIER('Table'[Number])),'Table'[Party ID])

How to Get Your Question Answered Quickly 

 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

 

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

markquisquirin's avatar
markquisquirin
Frequent Visitor
3 years ago

Hi v-polly-msft, I am looking for a DAX solution as well, thanks for this. I will try and let you know the result.

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    3 years ago

    if you want to do that in DAX you can use REMOVEFILTERS or otherwise bend the column filter to the WSM value.

    • markquisquirin's avatar
      markquisquirin
      Frequent Visitor
      3 years ago

      Hi Ibendlin, wow thanks. Would you be able to show me how I can do that? I tried REMOVEFILTERS before, but it didn't work. 😞 

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        3 years ago
        WSM DAX = CALCULATE(max(Query1[Party ID]),REMOVEFILTERS(Query1[Party ID]),Query1[Link Type]="WSM")