Help with Annualized Measure

JMAlloway — Thu, 05 Aug 2021 19:38:25 GMT

I have a very simple calculated measure that provides an annulized termination figure for the current year. What I would like to do, is modify this measure to only calculate the annualized figure for the current year only, otherwise display the total from previous years. How would I best achieve this? I thought I could use an IF, but it does not work becasue I believe that I cannot mix columns and measures in this command. Thanks for any info

Annualized = DIVIDE([Terminations YTD],[MonthsPassed])*12

Re: Help with Annualized Measure

amitchandak — Fri, 06 Aug 2021 06:01:02 GMT

JMAlloway , Not sure on other condition , say

Annualized = var _1 = DIVIDE([Terminations YTD],[MonthsPassed])*12 var _2 = [Terminations LYTD] return if(isblank(_1), _2, _1) ///// example to get LYTD Last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd("Date"[Date],-1,Year),"12/31"))

topic Re: Help with Annualized Measure in DAX Commands and Tips

Help with Annualized Measure

Re: Help with Annualized Measure