Forum Discussion

FrankS72's avatar
FrankS72
Regular Visitor
6 years ago
Solved

Calculated Column

I'm struggling to performa required calc, which I want to do in a new column.   Example Data: Table: Monthly_Sales                 Consultant Month Sales Best Month % Best A...
Need Help
  • Fowmy's avatar
    Fowmy
    6 years ago

    FrankS72 

     

    Try This:

     Best NEW = 

VAR BEST = CALCULATE( MAX(SALES[Sales]),ALLEXCEPT(SALES,SALES[Consultant]))

RETURN

BEST

     

    % vs BEST = 

DIVIDE(
    SALES[Sales],
    SALES[Best NEW]
)

     

    ________________________

    Did I answer your question? Mark this post as a solution, this will help others!.

    I accept KUDOS 🙂

    YouTube, LinkedIn





Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi FrankS72 ,

You can create calculated columns or measures to achieve it:

1. Create calculated columns

Best Month = CALCULATE(MAX('Monthly_Sales'[Sales]),FILTER('Monthly_Sales','Monthly_Sales'[Consultant]=EARLIER('Monthly_Sales'[Consultant])))
% Best = DIVIDE('Monthly_Sales'[Sales],'Monthly_Sales'[Best Month])

2. Create measures

Measure = CALCULATE(MAX('Monthly_Sales'[Sales]),FILTER(ALL('Monthly_Sales'),'Monthly_Sales'[Consultant]=MAX('Monthly_Sales'[Consultant])))
Measure 2 = DIVIDE(MAX('Monthly_Sales'[Sales]),[Measure])

Best Regards

Rena