web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Get last 3 monthn's sa...
Power Automate
Unanswered

Get last 3 monthn's sale summation

(0) ShareShare
ReportReport
Posted on by 6,048 Super User 2024 Season 1

Below is the sample dataset i have. Except for the last 3 month sales other columns are hard coded. User will enter data in it. I want to set up a business rule or power automate flow. That sums up last 3 months sales of perticular product and put it in that colum. For eg. Product A Jan-23 sale is 5000, Dec-22 sale is 5000 and Nov-22 sale is 5000. So the value will be 15000. How would i do that? I have full control over solution design, So easiest way would be good. Thank you.

 

Month-Year Name Current Month Sale Last 3 Month Sale
Jan-23 Product A 5000 15000
Jan-23 Product B 10000 30000
Jan-23 Product C 15000 45000
Dec-22 Product A 5000 11000
Dec-22 Product B 10000 22000
Dec-22 Product C 15000 33000
Nov-22 Product A 5000 -
Nov-22 Product B 10000 -
Nov-22 Product C 15000 -
Oct-22 Product A 1000 -
Oct-22 Product B 2000 -
Oct-22 Product C 3000 -
Categories:
I have the same question (0)
  • lbendlin Profile Picture
    8,474 Super User 2025 Season 2 on at
    Re: Get last 3 monthn's sale summation

    Is that a Power BI dataset? If yes then run a DAX query that implements your business logic.  Ideally your dataset's data model includes a calendar table so you can use the standard time intelligence functions in DAX.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 497 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 477 Super User 2025 Season 2

#3
chiaraalina Profile Picture

chiaraalina 242

Last 30 days Overall leaderboard