If statement involving subtraction. From Excel to BI.

[ianneg77]

I am looking to recreate an if statement from Excel in Power BI. But it is more than a simple If statement where I could just use a conditional column in BI. Maybe I am over-complicating it but I wanted to see if someone could point me in the right direction.

[v-ljerr-msft · Accepted solution]

Hi @ianneg77,

If I understand you correctly, you should be able to use the formula below to create a new calculate column in your table to get the same result in Power BI. 

Column =
IF (
    'Table1'[Request Date] - 'Table1'[Order Date]
        > 2,
    'Table1'[Ship Date] - 'Table1'[Request Date],
    'Table1'[Ship Date]
        - ( 'Table1'[Order Date] = 2 )
)

Note: You'll need to replace 'Table1' with your real table name.

Regards

[ianneg77]

Excellent, that works! I was messing up the syntax when attempting. Thank you. 

[ricardocamargos]

Hi @ianneg77,

Check this link:

https://msdn.microsoft.com/en-us/library/ee634824.aspx

Ricardo