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.

ryan_mayu's avatar
ryan_mayu
Super User
2 years ago

stevehuff 

you can try this

Column = 
VAR _last=maxx(FILTER('Table','Table'[Building]=EARLIER('Table'[Building])&&'Table'[Move-In Date]<EARLIER('Table'[Move-In Date])),'Table'[Move-In Date])
return if(ISBLANK(_last),BLANK(),'Table'[Rent]/maxx(FILTER('Table','Table'[Building]=EARLIER('Table'[Building])&&'Table'[Move-In Date]=_last),'Table'[Rent])-1)

stevehuff's avatar
stevehuff
Frequent Visitor
2 years ago

Hey ryan_mayu 

Thanks for the help! I'm still having some difficulties here. When I entered this in, I got the following error message. Any ideas on how/where to convert the Value/Format function?