Forum Discussion
asdf1608
Helper V
3 years agoFacing 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
- lbendlin
Super User
Can you describe the business problem behind the formula?