Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
asdf1608
Helper V
Helper V

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 3
lbendlin
Super User
Super User

Can you describe the business problem behind the formula?

@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

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.