Forum Discussion

asdf1608's avatar
asdf1608
Icon for Helper V rankHelper V
3 years ago
Solved

datetrunc in power BI

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?

 

2 Replies

    • asdf1608's avatar
      asdf1608
      Icon for Helper V rankHelper V
      3 years ago

      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