Forum Discussion

Sime's avatar
Sime
Helper I
2 years ago
Solved

Row Difference BY Period

Hi All,   I am calculating Earned Value by period based on the % of movement mulitplied by a budget figure. On occassion the budget figure changes and therefore the total EV is not accurate due to...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    2 years ago

    Hi,

    Assuming you have a Calendar Table with a relationship (Many to One and Single) from the Date column of your Data Table to the Date column of the Calendar Table AND to your visual, you have dragged Month and Year from the Calendar Table, write these measures:

    Previous month budget = calculate([Budget],previousmonth(Calendar[date]))

    Diff = [Budget]-[Previous month budget]

    Hope this helps.

  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Sime 

     

    If your source data table is like the sample data provided, you can create a calculated column with below DAX:

    Difference = 
var curMonth = 'Table'[Period]
var preBudget = CALCULATE(SUM('Table'[Budget]),ALL('Table'),'Table'[Period]=EOMONTH(curMonth,-1))
return
'Table'[Budget] - preBudget

     

    Best Regards,
    Jing
    If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!