Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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
Solved! Go to Solution.
@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"))
@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"))
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
16 | |
13 | |
12 | |
11 | |
11 |
User | Count |
---|---|
19 | |
14 | |
14 | |
11 | |
9 |