datetrunc in power BI

[asdf1608]

I am converting the tableau functions to Power BI.

I am having doubts in this

datetrunc(year, [Date])

How do I convert this to power DAX

For Example: if the date is 12/4/2022, after datetrunc the answer should be 1/1/2022

if date = 3/6/2019 answer  = 1/1/2019

How do I achieve this in poewr BI?

[Greg_Deckler · Accepted solution]

@asdf1608 Try DATE(YEAR([Date]),1,1)

[asdf1608]

@Greg_Deckler it works perfectly. Now the entire calculation field. Please help me with this alone.

DATEADD('day',15-DATEPART('weekday',DATEADD('month',2,DATETRUNC('year',[CST Start Date & Time])))

For this only I asked datetrunc. But other thins is also difficult for me

Please help in this is required.

Thanks in advance