Forum Discussion

AFra's avatar
AFra
Helper III
6 years ago
Solved

Group values based on another table

Hi all,    I have a table with a list of salaries (Table A.), and another table with the categories I'd like to add (Table B.)  Table A.  Idperson Salary 57927 14 669,47 € 63584 10 61...
Need Help
AFra's avatar
AFra
Helper III
6 years ago

Thanks Mariusz , it works nicely : ) 

 

Car revenus ménage = CALCULATE(
                VALUES('cat revenus'[Rev ménage (groups)]) ;
                FILTER('cat revenus';
                            data[Rev ménage]>='cat revenus'[MinVal]
                            && data[Rev ménage] < 'cat revenus'[MaxVal]
                 )
)
  • Mariusz's avatar
    Mariusz
    Community Champion
    6 years ago

    Hi AFra 

     

    Happy to help!

     

     

    Best Regards,
    Mariusz

    Please feel free to connect with me.
    Mariusz Repczynski