cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper III

## 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 .

1 ACCEPTED SOLUTION
Super User

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 quickly

Regards,
Rita Fainshtein | Microsoft MVP
3 REPLIES 3
Super User

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 quickly

Regards,
Rita Fainshtein | Microsoft MVP
Helper III

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

Super User

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
Regards,
Rita Fainshtein | Microsoft MVP

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.