topic Re: How to calculate Real GDP in DAX in DAX Commands and Tips

How to calculate Real GDP in DAX

Radhika_Kanaka — Wed, 24 Aug 2022 01:35:47 GMT

Hi,

I have to calculate Real GDP for my Data.

I calculated Nominal GDP by multiplying price index and Quantity index .

To calculate Real GDP, I need to multiply quantity index of base year with price index of the previous year. I am trying to create a calculated column and measure but not successful. Please provide your inputs.

Sample data for reference:

I am taking 2001 as the base year . I need to calculate real GDP by multiplying 2001 quantity with 2000 price and also 2001 quantity with 2002 price. Please let me know what logic can be used , as I tried creating calculated columns and did not work .

Appreciate your time.

Thanks,

Radhika Lanka

Re: How to calculate Real GDP in DAX

amitchandak — Wed, 24 Aug 2022 03:59:30 GMT

Radhika_Kanaka , if you always need the price of 2000

a new column

= maxx(filter(Table, Table[Year] =2000) , [Price]) * [Quantity]

Re: How to calculate Real GDP in DAX

Radhika_Kanaka — Wed, 24 Aug 2022 13:51:26 GMT

amitchandak thanks much for the help.

Would you also be able to provide details on how to find Nominal GDP, Real GDP ? I have been trying to calculate GDP for the above sample data .

Appreciate your time.

Thanks,

Radhika Lanka

Re: How to calculate Real GDP in DAX

Anonymous — Fri, 26 Aug 2022 08:32:13 GMT

Hi Radhika_Kanaka ,

I suggest you to try this measure.

GDP = VAR _CY_Quantity = CALCULATE(SUM('Table'[quantity])) VAR _LY_Price = CALCULATE(SUM('Table'[price]),FILTER(ALL('Table'),'Table'[year] = MAX('Table'[year])-1)) VAR _NY_Price = CALCULATE(SUM('Table'[price]),FILTER(ALL('Table'),'Table'[year] = MAX('Table'[year])+1)) RETURN _CY_Quantity * _LY_Price + _CY_Quantity * _NY_Price

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.