How to calculate Annualization In Dax? Help needed!

[Herson]

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 below.

 

What I hope to achieve is having a dax calcualtion where I could select any given month period the
(Selected month) in the bracket will change accordingly.
ROA(KPI) = [AA_400000]/(Selected month)*12/[AA_500000]

I wonder how this could be done in the dax formula? The output will be a percentage figure.

PBIX File:

https://drive.google.com/file/d/1qJ8nSbO6pO4fXDgY-YFSrNQOR7oLyzTz/view?usp=sharing 

Thanks in advance

Laurence

[filipeoliveira · Accepted solution]

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]

Hi filipeoliveira,

Thanks for looking into the problem. It worked!

Laurence