Forum Discussion

dw700d's avatar
dw700d
Icon for Post Patron rankPost Patron
5 years ago
Solved

Calculating date difference

I’m not sure if this is possible in power bi. But if it is I could use some guidance. I am trying to calculate the difference between two dates. The first date is a purchase date. The second date is ...
Need Help
  • v-xulin-mstf's avatar
    v-xulin-mstf
    5 years ago

    Hi dw700d,

     

    Try measure as:

    Measure =

var _date1=

CALCULATE(

    MAX(Table1[purchase date]),

    FILTER(

        Table1,

        Table1[Order number]=MAX(Table2[Order number])

    )

)

var _date2=

CALCULATE(

    MAX(Table2[Payment Date                 ]),

    FILTER(

        ALL(Table2),

        Table2[Order number]=MAX(Table2[Order number])))

return

DATEDIFF(_date1,_date2,DAY)

    Here is the output:

     

    Here is the demo, please try it: Calculating date difference

    Best Regards,

    Link

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

Hi,

In the first table, you may write this calculated column formula

Most recent date = calculate(max('table2'[Payment Date]),filter('table2','table2'[Order Number]=earlier('table2'[Order Number])))

Hope this helps.