Facing problem in converting tableau calculated fields to power BI DAX measures

[asdf1608]

I am converting the tbleau measures to Power DAX measures. Help in this is needed.

1) column1 = DATEADD('hour',-6,[column2])

2)column3=

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.

Please Help.

Thanks in advance

[lbendlin]

Can you describe the business problem behind the formula?

[asdf1608]

@lbendlin  basically I need the datetrunc part.

In tableau datetrunc(year,column1)

For example if the date is 12/3/2021 after datetrunc if results "1/1/2021"

if the date is 3/5/2021 then the result is 1/1/2021

How to achieve this in power BI

[lbendlin]

DATE(YEAR([column1]),1,1)