Calcualted column

[navneet0512]

I am subtrating two date column which is calculated but getting output as summed don't know why . Below is one example of that right one is good as it is 197 it calualyed in M query . left one is calculted in power bi desktop calulated column .

Actual Cycle Time = if(ISBLANK(SS[ActualShipDate]),BLANK(),IF(ISBLANK(SS[OrderReceivedDate]),BLANK(),(DATEDIFF(SS[ActualShipDate],SS[OrderReceivedDate],DAY))))

[Ritaf1983 · Accepted solution]

Hi @navneet0512 
Try this DAX for calculated column :

Actual Cycle Time = if(ISBLANK('Table'[ship date])||ISBLANK('Table'[recieved date]),BLANK(),DATEDIFF('Table'[recieved date],'Table'[ship date],DAY))
Unfortunately, I am out of the limit of pictures that I can attach to the discussions, so I created a file with an example:

Link to PBIX 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Ritaf1983 · Accepted solution]

Hi @navneet0512 
Try this DAX for calculated column :

Actual Cycle Time = if(ISBLANK('Table'[ship date])||ISBLANK('Table'[recieved date]),BLANK(),DATEDIFF('Table'[recieved date],'Table'[ship date],DAY))
Unfortunately, I am out of the limit of pictures that I can attach to the discussions, so I created a file with an example:

Link to PBIX 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[navneet0512]

want to subtract order recieved date from actual ship date means [actual shipdate - order recieved date]

[Ritaf1983 · Accepted solution]

Hi @navneet0512  you can replace the order of the parameters of the formula.
Just note that in your example start day is after the end day ...so the result will be (-197)

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly