Forum Discussion
Solved
Creating New Column in Data Set: Commercial Real Estate
Hello - I am creating a new report in PowerBi to try and capture the amount of time it takes my team to lease and build out a commerical space. Eventually, I will want to filter this list into two b...
pls try this
Column = VAR _min=CALCULATE(min('Table'[Leasing Date]),ALLEXCEPT('Table','Table'[SpaceID])) VAR _max=CALCULATE(max('Table'[Leasing Date]),ALLEXCEPT('Table','Table'[SpaceID])) return if('Table'[Leasing Date]=_min,"Initial Buildout",if('Table'[Leasing Date]=_max,"Retananting"))
