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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.