Forum Discussion

donodackal's avatar
donodackal
Helper I
4 years ago
Solved

Help creating new DAX Column

Hi there   The below table is a summary of multiple invoices summed up against the supplier. I would like to create a new column that broadly categories each supplier based on their Total Spend (Th...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi donodackal ,

     

    Please try:

    Categories = 
var _sum=CALCULATE(SUM('Table'[ Total Spend ]),ALLEXCEPT('Table','Table'[Supplier Name]))
return SWITCH(TRUE(), _sum>1000000 ,"million-dollar club",_sum>=200000 ,"200K to 1M club",_sum>=25000 ,"25k to 200k club","Penny value club")

    Output:

     

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

donodackal's avatar
donodackal
Helper I
4 years ago

The PBI file has sensitive data.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
4 years ago

Anonymise the data in the PBI file and share the download link.  Ensure your measures are already written in that file.