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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
HARIKRISHNA_T
Frequent Visitor

calculate

 
1 ACCEPTED SOLUTION

Hi,

You may download my PBI file from here.

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

8 REPLIES 8
DimaMD
Solution Sage
Solution Sage

@HARIKRISHNA_T hi, Should your desired result be like this?
P02 = 130 - (60+60) = 10
P03 - 10- (30+60) = -50


__________________________________________

Thank you for your like and decision

__________________________________________

Greetings from Ukraine

To help me grow PayPal: embirddima@gmail.com

Hi @DimaMD 

 

Greetings !

 

My Formula would for Opening Balance of current period =  Closing Balance of previous period - Revenue(Current period) +  Cash (Current Month).

 

I am looking for an formula to Calulate from Period 2 to Period 12.

 

Thanks in Advance.

 

regards,

Hari 

@HARIKRISHNA_T Do your tables have dates?


__________________________________________

Thank you for your like and decision

__________________________________________

Greetings from Ukraine

To help me grow PayPal: embirddima@gmail.com

Thanks @DimaMD for quick response

 

Here is the link for the table.

 

https://docs.google.com/spreadsheets/d/12TeSvdeEERgmgxl9rkeKaoe3xpeFVzvY/edit?usp=share_link&ouid=10... 

 

Regards,

Hari 

 

Hi,

You may download my PBI file from here.

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

@HARIKRISHNA_T Can you explain the calculation logic for P01?


__________________________________________

Thank you for your like and decision

__________________________________________

Greetings from Ukraine

To help me grow PayPal: embirddima@gmail.com

Hi @DimaMD 

 

Till FY23 Period 1, we have actuals in Data. Now we have forecast data for REVENUE & CASH till FY23. However, We dont have Forecasted Unbilled balances from Fy23 P2-P12.

 

Hence, Using Actuals Unbilled balance, wanted to calculate future Unbilled balances basing on Forecasted Cash And revenue.

 

Regards,

hari 

Hi @DimaMD 

 

any luck on this query.

 

regards,

Hari

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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