Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Calculate difference between different value in same column against its ID.

i need to calculate the difference between different months value budgets, and the result should be the difference of two month  against the same ID. like, e.g., ID PE-262. Now i need to find the di...
  • tharunkumarRTK's avatar
    tharunkumarRTK
    2 years ago

    Anonymous 

    Differnce_month = 
Var __Project = 'Table'[ID]
Var __FilterforCurrentProject = FILTER('Table', 'Table'[ID] = __Project)
Var __FirstDateOfProject = MINX(__FilterforCurrentProject,  'Table'[Version] ) 
Var __PreviousMonth = EOMONTH('Table'[Version],-2) + 1 
Var __PrevMonthBudget = MINX(FILTER(__FilterforCurrentProject, 'Table'[Version] = __PreviousMonth), 'Table'[Budget])
RETURN IF('Table'[Version] <> __FirstDateOfProject, __PrevMonthBudget - 'Table'[Budget] , 0)


    Need Power BI consultation, hire me on UpWork .


    If the post helps please give a thumbs up



    If it solves your issue, please accept it as the solution to help the other members find it more quickly.




    Tharun



Anonymous's avatar
Anonymous
Not applicable
2 years ago

Dear tharunkumarRTK 
as Per formula , it's showing in Jan.24 , value  0, which is not accurate  as it should show variance of Dec.23 - Jan.24= Variance in Jan.24 if have , and same for Future years. only zero should reflect at the starting Month of the Project, as its, Mar.23 which is showing 0, accurate .