Forum Discussion

Cadenze's avatar
Cadenze
Icon for Helper II rankHelper II
3 years ago
Solved

How to count posts for dates before yesterday while transdate is fixed

I log invoice data every day, and would like to count the number of invoices that were issued before yesterday for orders that were confirmed for yesterday. I.e. the number of orders that were due ye...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    Cadenze ,  Try like

    Shipped early =
    countrows(filter('DeliveryDetails', 'DeliveryDetails'[InvoiceDate] = Today()-1 && 'DeliveryDetails'[FirstConfirmedDlvDate]<today()-1 ) )

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Cadenze ,  Try like

Shipped early =
countrows(filter('DeliveryDetails', 'DeliveryDetails'[InvoiceDate] = Today()-1 && 'DeliveryDetails'[FirstConfirmedDlvDate]<today()-1 ) )

Cadenze's avatar
Cadenze
Icon for Helper II rankHelper II
3 years ago

This is the closest I have come to a working measure, so thank you for that. And once I put my head back on, I found that I needed to switch InvoiceDate and FirstConfirmedDlvDate in you excellent query :-).