Forum Discussion
last 3 days data
hi all, i am trying to show the no. of users in the past 3 days.
is there a way to always show the last 3 days of data without any filtering?
Thnaks.
Try
last 3 days = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[date],max(Sales[Sales Date]),-3,DAY))Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
3 Replies
- amitchandak
Super User
Try
last 3 days = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[date],max(Sales[Sales Date]),-3,DAY))Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601 
v-lionel-msftCommunity Support
Hi Anonymous ,
Did amitchandak 's answer solve your problem?
If it is sloved, could you kindly accept it as a solution to close this case?
If not, please let me know and re-upload your file, because I can't download your file.
Best Regards
Lionel Chen