Calculate Annualized Percentage by revising existing DAX Calculation

[Mk60]

New to PBI and DAX. I am trying to revise my existing DAX calculation to accommodate for a simple annualization calculation, which we can simply achieve in excel. I assume there is a simple fix for this, but when I try to modify my existing calc I am getting this error: “The SUM function only accepts a column reference as an argument”?

All I want is to get calculated values I have in column D, (see excel formula in cell D13 which can accommodate that), to replace my original DAX calculation values in column E, (which are not annualized by days in one quarter):

Here’s my current DAX calculation I am using to get values in column E:

 QTD-BALANCE-2As%-Annualized =

    SUM(Query1[BALANCE-2])/CALCULATE(SUM(Query1[BALANCE-1]),

    ALL(Query1[BALANCE-1]))

Any suggestion would be much appreciated! Thanks in advance!

[Mk60 · Accepted solution]

Sorry, small correction: Correct Calculated Measure name for my My DAX for column E should be :NOT Annualized"

[v-jialongy-msft]

Hi @Mk60 

Please try the following DAX:

NOT Annualized = 
DIVIDE(
    SUM(Query1[BALANCE-2])/92*365,
    CALCULATE(
        SUM(Query1[BALANCE-1]),
        ALL(Query1[BALANCE-1])
    )
)

Best Regards,

Jayleny

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

[Mk60]

I hope I am not bothering you, as I have another probably simple DAX question, hopefully you can help me with this one: What DAX calc could give me Quarter over Quarter change in dollars for Metrics 1-5 in column A, in this sample attached, to calculate and populate columns E & F:

Thank you very much in advance, Jayleny!

[Mk60 · Accepted solution]

Sorry, small correction: Correct Calculated Measure name for my My DAX for column E should be :NOT Annualized"

[Mk60 · Accepted solution]

Hi Jayleny,

This works perfect! I found some temporary worjaround, but this is perfect, exactly what I wanted. Thank you so much for your time and willingness to help. Much apprecited!