Forum Discussion

Sol_idSnake's avatar
Sol_idSnake
New Member
3 years ago
Solved

Multiplying Measures by Varied Month Number

I am trying to create a measure to display the following equation: (Annual Target / Months) * (Current Month Number). I have created the following equation and understand that it works correctly, up ...
Add "IF" before calculate
Division
Month
Month Calculation
  • AnthonyGenovese's avatar
    AnthonyGenovese
    3 years ago

    I would do something like 

    LiveTarget = 
    var curMonth = if(month(today())>3, month(today())-3, month(today())+9)
    var result = ([TARGET 2024]) / MAX( MonthNumber[Month Number]) * curMonth
    return result

     

    If this post was helpful, please kudos or accept the answer as a solution.
    ~ Anthony Genovese
    Need more PBI help? PM me for affordable, dedicated training or consultant recomendations!

AnthonyGenovese's avatar
AnthonyGenovese
Icon for Resolver III rankResolver III
3 years ago

I would do something like 

LiveTarget = 
var curMonth = if(month(today())>3, month(today())-3, month(today())+9)
var result = ([TARGET 2024]) / MAX( MonthNumber[Month Number]) * curMonth
return result

 

If this post was helpful, please kudos or accept the answer as a solution.
~ Anthony Genovese
Need more PBI help? PM me for affordable, dedicated training or consultant recomendations!

  • Sol_idSnake's avatar
    Sol_idSnake
    New Member
    3 years ago

    Thank you Anthony, this was the solution. I'm very grateful and you've also taught me a new function. Have a great day.