Forum Discussion

Herson's avatar
Herson
Regular Visitor
4 years ago
Solved

How to calculate Annualization In Dax? Help needed!

Hi, I am having trouble calculate Annualized Return on Assets. The expected calculation is Earning/Asset*(Selected Month/12). There are two tables: Date Table and Pivoted Financial table shown bel...
DAX
financial data
  • filipeoliveira's avatar
    filipeoliveira
    4 years ago

    If the two tables are related by Date, you can use something like:

     

    ROA(KPI) = 
    VAR SELECTED_MONTH = MONTH(SELECTEDVALUE(DATE_TABLE[DATE]))

    RETURN

    [AA_400000]/SELECTED_MONTH*12/[AA_500000]

     

    Note that it will only work in a table visual.

filipeoliveira's avatar
filipeoliveira
Icon for Helper I rankHelper I
4 years ago

If the two tables are related by Date, you can use something like:

 

ROA(KPI) = 
VAR SELECTED_MONTH = MONTH(SELECTEDVALUE(DATE_TABLE[DATE]))

RETURN

[AA_400000]/SELECTED_MONTH*12/[AA_500000]

 

Note that it will only work in a table visual.

Herson's avatar
Herson
Regular Visitor
4 years ago

Hi filipeoliveira,

 

Thanks for looking into the problem. It worked!

 

Laurence