To convert tableau calculation to PBI DAX

[asdf1608]

I need to convert the tableau calculation to PBI Dax

if DATETRUNC('week', [Date1) < DATETRUNC('week', [Date2])
then 0
else zn([column1])+zn([Column2])

if ActualDate is less than delivered date then 0 else the sum should come.

I tried the same concept in power BI

a = if(

(Append1[actualDate]- WEEKDAY(Append1[actual Date] , 2) +1).day<

(Append1[delivered Date]- WEEKDAY(Append1[deliveredDate] , 2) +1).day,0,valiue+calculation1)

But the result is wrong.

Have attached the file here

sample.pbix

Help in this is needed.

Thanks in advance

[lbendlin]

Don't use the .[day] hierarchy item.

calculated1 = IF(Sheet1[week1]<Sheet1[Week2],0,Sheet1[Valiue])

[asdf1608]

@lbendlin Can you show me how throught the power BI file. I tried the same yet the result seems to be wrong.

sample.pbix

Help is really appreciated.