Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
bryantmikdbi
Frequent Visitor

Beginning of Month Value using Last Month Value

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:

BrandMonthIDInv U
A20210510
A20210620
A20210750
A20210840
B20210520
B20210660
B20210730
B20210810

This table is joined to a data table (below) - joined by Monthid:

MonthIDMonth
202105May
202106June
202107July
202108August
202105May
202106June
202107July
202108

August

 

Desired Result:

BrandMonthInv UBOM Ivn U
AMay10 
AJune2010
AJuly5020
AAugust4050
BMay20 
BJune6020
BJuly3060
BAugust1030

 

Basically trying to get the BOM Inv U based off the last month Inv U value.

 

Any help would be great!

1 REPLY 1
Tanushree_Kapse
Impactful Individual
Impactful Individual

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.

 

 

 

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors