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

Hi Anonymous 

 

1. I am always appreciated for your kindly help. 😍

2. Actually, I shorted my data by operation to get it shorter because the original one is too long as 1 operation has many people working for. I am sorry about not showing enough data.

3. Because of my mistake, when running fomular, it counted x2, x3, x4 ... 

 

Therefore, I edited the fomular by deviding to countax for removing duplicates value.

The fomular seems to be loong, doesn't it ? 😊

Is there another way to make it shorter?

 

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi thongnguyen2414 

 

It does not matter whether the code is long or not, but it does matter whether it has side effect...I am not a fan of EARLIER, so always use Variable...you can go to DAX Formatter to format your DAX code, practising with different formulas and you will find a better way

 

DAX Formatter by SQLBI