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