Forum Discussion

dw700d's avatar
dw700d
Post 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

v-xulin-mstf's avatar
v-xulin-mstf
Community Support
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