Skip to content

Navigation Menu

Explore
By company size
By use case
By industry
View all solutions
Topics
- AI
- DevOps
- Security
- Software Development
- View all
Explore
- GitHub Sponsors
  Fund open source developers
- The ReadME Project
  GitHub community articles
Repositories
- Enterprise platform
  AI-powered developer platform
Available add-ons
Pricing

Search code, repositories, users, issues, pull requests...

Search

Clear

Search syntax tips

Provide feedback

We read every piece of feedback, and take your input very seriously.

Include my email address so I can be contacted

Saved searches

Use saved searches to filter your results more quickly

Name

Query

To see all available qualifiers, see our documentation.

You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session.

Dismiss alert

databayes / Transactional-Measures Public

Notifications You must be signed in to change notification settings
Fork 0
Star 0

Code
Issues
Pull requests
Actions
Projects
Security
Insights

Additional navigation options

Code
Issues
Pull requests
Actions
Projects
Security
Insights

Breadcrumbs

Transactional-Measures

/

Day 13 Lost customers in 2021

Latest commit

History

7 lines (7 loc) · 285 Bytes

Breadcrumbs

Transactional-Measures

/

Day 13 Lost customers in 2021

File metadata and controls

7 lines (7 loc) · 285 Bytes

1

2

3

4

5

6

7

Lost Customers in 2021 =

VAR Jan1st = DATE(YEAR(TODAY()), 1, 1)

VAR Customers2020 = COUNTROWS(

FILTER(

SUMMARIZE(Orders, Orders[CustomerID], "FirstOrder", LASTNONBLANKVALUE(Orders[CustomerID], MAX(Orders[OrderDate]))),

[FirstOrder] < Jan1st))

RETURN Customers2020

Footer

© 2025 GitHub, Inc.

Footer navigation

Terms
Privacy
Security
Status
Docs
Contact

You can’t perform that action at this time.