Forum Discussion
Calcualted column
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 .
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:If this post helps, then please consider Accepting it as the solution to help the other members find it more quicklyHi 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
3 Replies
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:If this post helps, then please consider Accepting it as the solution to help the other members find it more quicklywant to subtract order recieved date from actual ship date means [actual shipdate - order recieved date]
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
