topic Re: Facing problem in converting tableau calculated fields to power BI DAX measures in DAX Commands and Tips

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

asdf1608 — Thu, 02 Mar 2023 12:30:56 GMT

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

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

lbendlin — Sat, 04 Mar 2023 01:28:07 GMT

Can you describe the business problem behind the formula?

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

asdf1608 — Wed, 08 Mar 2023 12:15:53 GMT

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

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

lbendlin — Wed, 08 Mar 2023 14:48:19 GMT

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