Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello - I'm trying to get Beg of Month Inventory to populate based on the last month Beg of Month Inv value. Below is a simplified version of the data and desired result.
Data Table:
Brand | MonthID | Inv U |
A | 202105 | 10 |
A | 202106 | 20 |
A | 202107 | 50 |
A | 202108 | 40 |
B | 202105 | 20 |
B | 202106 | 60 |
B | 202107 | 30 |
B | 202108 | 10 |
This table is joined to a data table (below) - joined by Monthid:
MonthID | Month |
202105 | May |
202106 | June |
202107 | July |
202108 | August |
202105 | May |
202106 | June |
202107 | July |
202108 | August |
Desired Result:
Brand | Month | Inv U | BOM Ivn U |
A | May | 10 | |
A | June | 20 | 10 |
A | July | 50 | 20 |
A | August | 40 | 50 |
B | May | 20 | |
B | June | 60 | 20 |
B | July | 30 | 60 |
B | August | 10 | 30 |
Basically trying to get the BOM Inv U based off the last month Inv U value.
Any help would be great!
Hi @bryantmikdbi ,
Measure_lastmonth= CALCULATE (SUM(Inv U), PREVIOUSMONTH(TABLE_2[Month]))
I hope this helps.
Mark it as a solution if I answered your question.
User | Count |
---|---|
25 | |
12 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
12 | |
11 | |
9 | |
6 |