Converting Tableau Calculation to PowerBI DAX

Hi Dragpunk ,

For first Line DATE(STR(DATEPART('year',[HighDateValue Max]))+'-'+STR(1)+'-'+STR(1)), you can use below DAX :

DATE(YEAR('Date Data'[HighDateValue Max ].[Date]), "1","1")

For Second Line DATE(STR(DATEPART('year',[HighDateValue Max]))+'-'+STR(1)+'-'+STR(1)), you can use below DAX:

DATE(YEAR('Date Data'[HighDateValue Max ].[Date]), "3","31")

And overall column can have below DAX expression:

DAX Result = IF('Date Data'[Renewal Date ].[Date] >= DATE(YEAR('Date Data'[HighDateValue Max ].[Date]), "1","1") && 'Date Data'[Renewal Date ].[Date] <= DATE(YEAR('Date Data'[HighDateValue Max ].[Date]), "3","31"), "1 Jan - 31 Mar")

This will give you below result for sample renewal date and HighDateValue Max,

If this answer helps, please mark it as an Accepted Solution so it would help others to find the solution.

Thanks!

Inogic Professional Service Division

An expert technical extension for your techno-functional business needs

Power Platform/Dynamics 365 CRM

Drop an email at [email protected]

Service:  http://www.inogic.com/services/ 

Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/