Forum Discussion

JMAlloway's avatar
JMAlloway
Icon for Helper I rankHelper I
5 years ago
Solved

Help with Annualized Measure

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...
  • amitchandak's avatar
    amitchandak
    5 years ago

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

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

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