Forum Discussion
difference between two date fileds
Hello All
how to calcualte difference of days between two dates from two tables, Also what happenes if source columns values are expected nulls how to handle this in logic.
Salesdate - sales table
Orderdate - order table
date diff( salesdate, orderdate, days)..?
Hi refint650
Thanks for reaching out to us.
First, you need to find the dates you want to compare from the two tables, and then use the datediff function.
for example,
measure=
var _date1= minx(filter(table1,table1[column1]="xxx"), [Salesdate])
var _date2= minx(filter(table2,table2[column1]="xxx"), [Orderdate])
return datediff(_date1,_date2,day)
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
refint650 , You need a common dimension joined to both tables
Sumx(Values(Order[Order]) , datediff( Min(sales[salesdate], max(Order[orderdate], days) )
same as this one
without agreagate function alternate way to find difference of date columns from two tables.?
Hi refint650
Thanks for reaching out to us.
First, you need to find the dates you want to compare from the two tables, and then use the datediff function.
for example,
measure=
var _date1= minx(filter(table1,table1[column1]="xxx"), [Salesdate])
var _date2= minx(filter(table2,table2[column1]="xxx"), [Orderdate])
return datediff(_date1,_date2,day)
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
