Need to converth the tableau measure to power BI

[asdf1608]

Need to convert this tableau measure to power BI.

IF DATEPART('weekday',DATEADD('month',10,DATETRUNC('year',[[column1]))) = 1

THEN DATEADD('day',0,DATEADD('hour',2,DATEADD('month',10,DATETRUNC('year',[column1]))))

ELSE DATEADD('day',8-DATEPART('weekday',DATEADD('month',10,DATETRUNC('year',[column1]))),
DATEADD('hour',2,DATEADD('month',10,DATETRUNC('year',[column1]))))

END

This is urgent.

Thanks in advance

[FreemanZ]

hi @asdf1608 

you would get a solution quicker, if your could describe your case with plain English and support it with sample data table and expected result. 

[asdf1608]

@FreemanZ  I understand your point. The result is a simple date. What I am not getting is the tableu measure dateadd.

 Simple formula behind that is

Dateadd('hour', 2, column1) i.e DATEADD(interval, number, date)

But in power BI how do I get this. It containes only year,quarter,month,day

I need this conversion from tableau to powre BI

[FreemanZ]

hi @asdf1608 

i still can't follow.  seems you have already check DATEADD in Power BI. 

Again,  you would get a solution quicker, if your could describe your case with plain English and support it with sample data table and expected result.