Forum Discussion

Dragpunk's avatar
Dragpunk
New Member
3 years ago

Converting Tableau Calculation to PowerBI DAX

Need help to convert the following below tableau calculation into dax   IF [Renewal Date] >= DATE(STR(DATEPART('year',[HighDateValue Max]))+'-'+STR(1)+'-'+STR(1)) AND [Renewal Date] <= DATE(STR(DA...
Mrxiang's avatar
Mrxiang
Icon for Helper II rankHelper II
3 years ago

IF([Renewal Date] >= DATE(YEAR(HighDateValue[Max])+'-'&TEXT(DAY(HighDateValue[Max])+1)+'-'&TEXT(MONTH(HighDateValue[Max])+1))
AND [Renewal Date] <= DATE(YEAR(HighDateValue[Max])+'-'&TEXT(DAY(HighDateValue[Max])+3)+'-'&TEXT(MONTH(HighDateValue[Max])+3)))
THEN "1 Jan - 31 Mar"
END