Divide price into historical and forecast by date

[paris]

Hi All,

Thank you for your help as always. 

Price on my price table contains both historical and forecast. I want to divide them into two columns by month/year.

For example, today is 14 Mar 2020.  

Data till end of Mar 2020 = Historical column 

Data from Apr 2020 = Forecast column 

Apprecaite if you can help!

All the best,

Paris

[amitchandak · Accepted solution]

@paris ,

Try New columns in the price table

Historical =
var _Max = EOmonth(today(),0)
return
if([date]<=_Max ,[Price],blank())

forecast =
var _Max = EOmonth(today(),0)
return
if([date]>_Max ,[Price],blank())

Appreciate your Kudos.

[paris]

Hello Amitchandak,

Thank you very much for your help. It seems I need to add ,0 after today().

Otherwise, it works perfectly. Thank you again. 

EOMONTH(today(),0)

All the best,

Paris

[amitchandak]

@paris , Thanks for pointing out. Corrected the post for anyone who looks for a similar solution. Kudos !!