Forum Discussion

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

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

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

3 Replies

  • Can you describe the business problem behind the formula?

    • asdf1608's avatar
      asdf1608
      Icon for Helper V rankHelper V

      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