topic Re: calculate in DAX Commands and Tips

calculate

HARIKRISHNA_T — Thu, 08 Dec 2022 06:45:32 GMT

Re: calculate

DimaMD — Fri, 02 Dec 2022 08:31:05 GMT

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

Re: calculate

HARIKRISHNA_T — Fri, 02 Dec 2022 08:47:50 GMT

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

Re: calculate

DimaMD — Fri, 02 Dec 2022 08:53:25 GMT

HARIKRISHNA_T Do your tables have dates?

Re: calculate

HARIKRISHNA_T — Fri, 02 Dec 2022 09:07:53 GMT

Thanks DimaMD for quick response

Here is the link for the table.

https://docs.google.com/spreadsheets/d/12TeSvdeEERgmgxl9rkeKaoe3xpeFVzvY/edit?usp=share_link&ouid=109019317121013628462&rtpof=true&sd=true

Regards,

Hari

Re: calculate

DimaMD — Fri, 02 Dec 2022 09:52:38 GMT

HARIKRISHNA_T Can you explain the calculation logic for P01?

Re: calculate

HARIKRISHNA_T — Fri, 02 Dec 2022 09:55:56 GMT

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

Re: calculate

HARIKRISHNA_T — Sat, 03 Dec 2022 12:18:10 GMT

Hi DimaMD

any luck on this query.

regards,

Hari

Re: calculate

Ashish_Mathur — Sun, 04 Dec 2022 02:49:21 GMT

Hi,

You may download my PBI file from here.

Hope this helps.