topic Re: To convert tableau calculation to PBI DAX in DAX Commands and Tips

To convert tableau calculation to PBI DAX

asdf1608 — Tue, 18 Apr 2023 09:53:48 GMT

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

Help in this is needed.

Thanks in advance

lbendlin — Thu, 20 Apr 2023 00:17:26 GMT

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

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

asdf1608 — Thu, 20 Apr 2023 10:20:50 GMT

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

Help is really appreciated.

lbendlin — Thu, 20 Apr 2023 13:07:35 GMT