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.
Current file:
https://drive.google.com/file/d/1f_OEc2p8UZzVb7VBKPfr4okNXa-BrwWJ/view?usp=sharing
Thanks
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.
3 Replies
- Greg_Deckler
Community Champion
See my article on Mean Time Between Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/339586
- amitchandak
Super User
Can you use trailing day measure and use it
trailing Day= CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Day))
- Icey
Community Support
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.
