Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Previous computation on Dax

Hi guys, just wanna ask on how can I compute from previous which will be based multiple column. See my expected out below and the computation that I did on Excel     Thank you so much!  
  • tamerj1's avatar
    tamerj1
    4 years ago

    Anonymous 
    Here is a sample file with the solution https://www.dropbox.com/t/7HLKwsbFecvw2MlK

    Existing = 
VAR CurrentDate = Data[Month]
VAR CurrentProgramTable =
    CALCULATETABLE ( Data, ALLEXCEPT ( Data, Data[Program] ) )
VAR TableOnAndBefore =
    FILTER ( CurrentProgramTable, Data[Month] <= CurrentDate )
RETURN
    SUMX ( TableOnAndBefore, Data[New] - Data[Removed] )
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi Anonymous 

Is this table visual or source data? Are New and Removed measures? What is the dax code?

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi tamerj1, the columns that doesn't have fill are from tables, while the yellow is I am expecting to be a calculated column