Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Get the value from Column

HI All,   i need the vaue which is repeating in the column.   Ex: from the below example Using DAX need to get the Value "5" for 2019 and Value "10" for 2018     Please let me know if yo...
Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi Anonymous 

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    Mariusz Repczynski

    Please see the attached file

     

     

     

     

Mariusz's avatar
Mariusz
Community Champion
6 years ago

HI Anonymous 

 

The column will be this.

Column = CALCULATE( MAX( 'Table'[Value] ), ALLEXCEPT( 'Table', 'Table'[Year] ) )

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
Mariusz Repczynski