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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
asdf1608
Helper V
Helper V

Need to converth the tableau measure to power BI

Need to convert this tableau measure to power BI.

 

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.

Thanks in advance

3 REPLIES 3
FreemanZ
Super User
Super User

hi @asdf1608 

you would get a solution quicker, if your could describe your case with plain English and support it with sample data table and expected result. 

@FreemanZ  I understand your point. The result is a simple date. What I am not getting is the tableu measure dateadd.

 Simple formula behind that is

Dateadd('hour', 2, column1) i.e DATEADD(intervalnumberdate)

But in power BI how do I get this. It containes only year,quarter,month,day

I need this conversion from tableau to powre BI

hi @asdf1608 

i still can't follow.  seems you have already check DATEADD in Power BI. 

 

Again,  you would get a solution quicker, if your could describe your case with plain English and support it with sample data table and expected result.

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.