calculate revenue when date in one table > date in another table

[giri41]

<HI Could someone help with the above issue please

Calculate(sum(revenue), appointment date> invoice date) not working

[Anonymous]

If the appointment date, invoice date and revenue are in the same table(Suppose Table1) then the below measure would work:

= Calculate(sum(revenue), Filter(Table1,appointment date> invoice date))

[giri41]

sorry they are in two different tables

[dax · Accepted solution]

Hi @giri41 , 

I am not clear  about your design, you could refer to my sample for details.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@giri41 , do they common dimension, where we can group and compare.

Refer this example of date diff, here you can compare or say datediff >0 or <0

https://community.powerbi.com/t5/Community-Blog/Decoding-Direct-Query-in-Power-BI-Part-2-Date-Differ...

[giri41]

Hi Amit,

thanks for your reply.

do you mean

calculate( sum(sales), datediff(invoicedate, appointmentdate,days)>0) ?????????????