create a new column based on another column by date

Heya,

You are comparing two different data types so it doesn't know what to return. I recreated your model and you have to do one of two things:

1. set Year column as Whole number and Value as Decimal number and use this formula:

Forum = 
VAR _year = YEAR(TODAY())
RETURN
IF(Sheet1[Year]>=_year,Sheet1[Value],0)

2. Set Year column as Whole number and Value as Text and use this formula:

Forum = 
VAR _year = YEAR(TODAY())
RETURN
IF(Sheet1[Year]>=_year,Sheet1[Value],"0")

The second option doesn't really make sense but it also works.

Best,

PS: if this solved your problem then please mark it as the solution so others can see it

Hi KMalik 
The year function returns the whole number, you cannot convert it to date format because the engine doesn't know that this is a year, it is just a number for it.

According to the error you are getting, there is issue with the data types.
1. You need the column year to be a whole number not a formatted date.
2 .If the wanted result is a number then it cannot return "" .
The "" is string so the data type should be a text

If you need it as a decimal number with blank cell you can use the formula :

Var2 =

var current_year = YEAR(TODAY())

RETURN

IF([Year]>=current_year,[Value],BLANK())

 

The updated pbix is attached

If my answer was helpful please give me a Kudos and accept as a Solution.