Forum Discussion
Decrease by day
Is there a way in which I can get the decrease from the previous day as in this example? I want it to return the sum of the negative numbers that will be apearing. by day an reflect it on the total. ...
Hi Anonymous ,
I find that Ashish_Mathur has posted a possible solution in your another post. Can it meet your requirements?
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Can you use trailing day measure and use it
trailing Day= CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Day))