Forum Discussion

Saes's avatar
Saes
Helper I
4 years ago
Solved

Help with building a calculated table

Hello all, I'm hoping someone can help with this issue I've been struggling with. I'm trying to build a table in PowerBI desktop that shows inflation figures and then a calculated column, which shows...
Need Help
  • Tahreem24's avatar
    Tahreem24
    4 years ago

    Saes Try this:

    Column =
    VAR res_ = CALCULATE(((37.45*SUM(TableB[Inflation Figure])))+37.45,FILTER((TableB),TableB[September Inflation Year]<=EARLIER(TableB[September Inflation Year])))
    RETURN IF(TableB[September Inflation Year]=1998,37.45,res_)
     
Saes's avatar
Saes
Helper I
4 years ago

Thanks Tahreem24 for clarifying. Is the calculated column reliant on having the Earning Value column already in place? The column I require is to calculate the Earning Value rather than duplicating an existing column. 

i.e. I know the dates, inflation figures and that the 1998 figure is $37.45 only. I need to be able to calculate the remaining figures based on this. Apologies if I've misunderstood or my post was not clear.

Tahreem24's avatar
Tahreem24
Super User
4 years ago

Saes Try this:

Column =
VAR res_ = CALCULATE(((37.45*SUM(TableB[Inflation Figure])))+37.45,FILTER((TableB),TableB[September Inflation Year]<=EARLIER(TableB[September Inflation Year])))
RETURN IF(TableB[September Inflation Year]=1998,37.45,res_)
 
  • Saes's avatar
    Saes
    Helper I
    4 years ago

    Thanks Tahreem24  for your help!