Conditions

[shavish]

The below code is not working, the date is returning no value on the coloumn(Looking with actual data, there are logical data to fill the condition)

date=IF((AND(condition1=null),(condition2=type)),DATEADD(date,20,year),DATEADD(date,30,year))

condition1 is a datatype date, condition 2 is datatype text

Also i welcome, if the above function is recommeded to be done in power query or powerbi desktop with add coloumn.

[PwerQueryKees]

Code is not working you say. Where does the variable date come from? 

I also notice that you assign the result also to a variable named date. This is possible, but you can use the new value ONLY in the same let/in context.

Please share your full M code (the complete query) here....

[Omid_Motamedise]

Can you provide the sample and result table?

[BA_Pete]

Hi @shavish ,

This may be as simple as using the correct DAX syntax. Try this:

YourColumn =
IF(
    ISBLANK(YourTable[condition1]) && YourTable[condition2] = "Type",
    DATEADD(YourTable[date], 20, YEAR),
    DATEADD(YourTable[date], 30, YEAR)
)

I've assumed 'condition1' and 'condition2' are names of other columns, so replace these accordingly to fit your actual data.

However, as per your question, I would almost always recommend adding new columns into Power Query to avoid the calculation needing to be done at runtime, something like this:

YourColumn =
if [condition1] = null and [condition2] = "Type" then Date.AddYears([date], 20)
else Date.AddYears([date], 30)

Pete

[PhilipTreacy]

@shavish 

Your explanation isn't very clear and it would really help if you supplied some data.

What do condition1=null and condition2=type mean?

Regards

Phil