Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Need help

Hello All,   I need to find something from my dataset which seems to be complicated for me, if anyone could help.     As you can see in the data, once a tenant moves out the net rent might...
Need Help
Show and Tell
Tips and Tricks
Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

 

Try this calculated column formula

 

=if(LOOKUPVALUE(price_check[Net Rent/ sqm],price_check[einzug],CALCULATE(MAX(price_check[einzug]),FILTER(price_check,price_check[Apartment Index]=EARLIER(price_check[Apartment Index])&&price_check[einzug]<EARLIER(price_check[einzug]))),price_check[Apartment Index],price_check[Apartment Index])>[Net Rent/ sqm],"Lower",if(LOOKUPVALUE(price_check[Net Rent/ sqm],price_check[einzug],CALCULATE(MAX(price_check[einzug]),FILTER(price_check,price_check[Apartment Index]=EARLIER(price_check[Apartment Index])&&price_check[einzug]<EARLIER(price_check[einzug]))),price_check[Apartment Index],price_check[Apartment Index])<[Net Rent/ sqm],"higher","Same"))

 

Hope this helps.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Ashish_Mathur, Thank you for the formula. But when I tried this, I'm getting "A table of multiple values was supplied where a single value was expected" error. What could be the reaosn for this ?