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_)
     
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!