Get last 3 monthn's sale summation

(0) Share

Report

Posted on by zmansuri

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	-

I have the same question (0)

All responses (1)

Answers (0)

lbendlin 8,361 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No