How to calculate Real GDP in DAX

[Radhika_Kanaka]

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

[Anonymous · Accepted solution]

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.

[Radhika_Kanaka]

@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

[amitchandak]

@Radhika_Kanaka , if you always need the price of 2000

a new column

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