Converting Measure to Calculated Column

[Anonymous]

Hi Everyone! Please see this PBIX file: https://drive.google.com/drive/folders/1tOkjeovhg5U8QKIsf9PyJ9-sRNewVnXU

I need help with converting the measure 'BP' to a Calculated Column. I tried pasting the same code as the measure as a Calculated Column but it returned Blanks for all the rows. Requesting all the help please ! 

For details on the logic behind measure 'BP' please refer this post : https://community.powerbi.com/t5/Desktop/Calculate-the-Latest-Price-from-within-previous-3-years-for...

Basically I need the same results as the measure but I need a Calculated Column instead. 

Let me know if there are any questions. 

Thanks in advance & kind regards !

[Anonymous · Accepted solution]

Hi @Anonymous ,

Please have a try.
Create a column.

column = var last= CALCULATE(MAX(Data[Year]),FILTER(Data,Data[Year]<EARLIER(Data[Year])&&Data[Country]=EARLIER(Data[Country])))
var three_=CALCULATE(MAX(Data[Price]),FILTER(Data,Data[Year]=last))
var not_in = CALCULATE(MAX(Data[Year]),FILTER(Data,Data[Year]<EARLIER(Data[Year])))
var rrr= CALCULATE(MAX(Data[Price]),FILTER(Data,Data[Year]=not_in))
var result = IF(last>=Data[Year]-3,three_,rrr)
return result

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards

Community Support Team _ Polly