Forum Discussion

stevehuff's avatar
stevehuff
Frequent Visitor
2 years ago
Solved

Creating a calculated column that depends on two different conditions

Hello! New to PowerBI and hoping that I can get some assistance in building out a report. We're looking to generate a report to show the percentage increase/decrease for lease amounts tied to the sam...
Need Help
Tutorial Requests
  • ryan_mayu's avatar
    ryan_mayu
    2 years ago

    stevehuff 

    is your data format correct? pls make sure the move in date is date type.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
2 years ago

Hi,

Write these calculated column formulas

Previous rent = LOOKUPVALUE(Data[Rent],Data[Move-In Date],CALCULATE(MAX(Data[Move-In Date]),FILTER(Data,Data[Building]=EARLIER(Data[Building])&&Data[Move-In Date]<EARLIER(Data[Move-In Date]))),Data[Building],Data[Building])
Rent growth (%) = DIVIDE(([Rent]-[Previous rent]),[Previous rent])

Hope this helps.