Forum Discussion

PBIfanatic's avatar
PBIfanatic
Icon for Helper V rankHelper V
6 years ago
Solved

FILTER used for age classification

Hi,   I am trying to get the below logic to work. The idea is to create an age group for the employees like 30-40, 40-50 etc.  I created an isolated table - Age Group with the groups I need.   N...
Need Help
  • PBIfanatic's avatar
    PBIfanatic
    6 years ago

    Hi Ashish_Mathur 

     

    Thanks a lot, it worked!!

    But I had to make a change, the storage mode was changed to import.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
6 years ago

Hi,

This calculated column formula in the Sales table should work

Age Group = CALCULATE(VALUES(AgeGroups[Age Group]),FILTER(AgeGroups,EARLIER(Sales[CustomerAge])>=AgeGroups[Min]&&EARLIER(Sales[CustomerAge])<AgeGroups[Max]))

If it does not work, then share the link from where i can download your PBI file.

Hope this helps.

PBIfanatic's avatar
PBIfanatic
Icon for Helper V rankHelper V
6 years ago

Hi Ashish_Mathur 

 

Thanks a lot, it worked!!

But I had to make a change, the storage mode was changed to import.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    6 years ago

    You are welcome.