Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Need help to calculate days

Days between "Designstartdate" and "datesentforreview" How do i achieve this?
Need Help
bhanu_gautam's avatar
bhanu_gautam
Icon for Super User rankSuper User
2 years ago

Anonymous , What is the relation between both tables

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Many to many? Beginner at power bi, any advice how can i calculate the days between two diff data set.

 

  • bhanu_gautam's avatar
    bhanu_gautam
    Icon for Super User rankSuper User
    2 years ago

    Anonymous , Create a new calculated column by going to modelling tab and click on new column

     

    DaysBetween =
    DATEDIFF(
        'ArtworkTracker'[Designstartdate],
        RELATED('Review List'[datesentforreview]),
        DAY
    )
    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      It gives me this

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago