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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Sai_Alkesh
Helper II
Helper II

Last 12 Months (LTM) Operating Profit Calculation Measure

Hello Experts,

Appreciate your help on creating a measure to calcuate the last twelve months (LTM) of core operating profit. Below is the table with data and how it is being calculated in Excel. FY = Fiscal Year from April to May and CY = Calendar Year from Jan to Dec.

FY Sep 21FY Oct 21FY Nov 21FY Dec 21FY Jan 21FY Feb 21FY Mar 21FY Apr 22FY May 22FY Jun 22FY Jul 22FY Aug 22FY Sep 22
CY Sep 21CY Oct 21CY Nov 21CY Dec 21CY Jan 22CY Feb 22CY Mar 22CY APR 22CY May 22FY Jun 22FY Jul 22FY Aug 22FY Sep 22
4800475258166250352422529655652323456585254863524585

 

Core operating profit for LTM, with period selected Sep 22 will be:

FY sep 21 value (9655) - FY mar 21 value(4800) = 5055 + FY sep 22 value (4585) = 9640

 

From the period selected month, it should pick up the fiscal year end month value. This value should be deducted from period selected less 12 months.

 

Can you please help me with this measure.

 

Regards,

2 REPLIES 2
Sai_Alkesh
Helper II
Helper II

Hello daXtreme

 

Sorry, if the logic is not clear. What i wish to accomplish is to get Core operating profit for the period September 2022, based on the following formula :

 

Value from Fiscal year end (march month) - value from September 2021 + value from September 2022.

 

based on the selection, the measure should calculate the operating profit for the selected period.

 

please do let me know, if this is still not clear and i will do a detailed write up.

 

thank you.

daXtreme
Solution Sage
Solution Sage

The data as well as the calc logic is not clear.

 

Please read this first: How to Get Your Question Answered Quickly - Microsoft Power BI Community

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors