Forum Discussion

AFra's avatar
AFra
Icon for Helper III rankHelper III
7 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
    Icon for Helper III rankHelper III
    7 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
      Icon for Community Champion rankCommunity Champion
      7 years ago

      Hi AFra 

       

      Happy to help!

       

       

      Best Regards,
      Mariusz

      Please feel free to connect with me.
      Mariusz Repczynski