Forum Discussion

thongnguyen2414's avatar
thongnguyen2414
Frequent Visitor
4 years ago
Solved

Using variable to calculate data of previous date & current date

Greetings all, and Have a nice Monday ðŸ˜š   1. I am in need of calculate data of current date, but need to pick up result form the previous date. (Because my data is too much with variety of date,...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi thongnguyen2414 

     

    My bad...mistakenly clicked the button to accept the solution...

    I modified the one from Anonymous a little bit

    Previous WIP1 = 
CALCULATE(SUM([Today WIP]),FILTER('Data',
'Data'[Description]=EARLIER('Data'[Description])
&&'Data'[Date]<EARLIER('Data'[Date])
&&'Data'[Line]=EARLIER('Data'[Line])
&&'Data'[File No]=EARLIER('Data'[File No])
&&[Op. No]=EARLIER('Data'[Op. No])))

    Anonymous  how can I undo Accept the solution?

thongnguyen2414's avatar
thongnguyen2414
Frequent Visitor
4 years ago

Hello

 

Could any one kindly help me to figure out how to calculate for the 'previous date Operation WIP' & 'ACCUM. Operation WIP' ? I tried but still not successfully.