cancel
Showing results for
Did you mean:
Regular Visitor

## Payroll Number Semi-Monthly

I would like to create a column using dax that gives me a count of payroll, starting over each year and increasing semi-monthly on the 1st and 16th of each month. For example, the date table will show:

 1/11/2019 1 1/12/2019 1 1/13/2019 1 1/14/2019 1 1/15/2019 2 1/16/2019 2 1/17/2019 2 1/18/2019 2 1/19/2019 2 1/20/2019 2 1/21/2019 2 1/22/2019 2 1/23/2019 2 1/24/2019 2 1/25/2019 2 1/26/2019 2 1/27/2019 2 1/28/2019 2 1/29/2019 2 1/30/2019 2 1/31/2019 2 2/1/2019 3 2/2/2019 3
1 ACCEPTED SOLUTION

Accepted Solutions
Super User

## Re: Payroll Number Semi-Monthly

Try this

```NewCol =
VAR Base_ = (2 * ( MONTH ( CalendarTable[Date] ) - 1 )) + 1
RETURN
SWITCH (TRUE ();
DAY ( CalendarTable[Date] ) < 16; Base_;
Base_ + 1
)```
4 REPLIES 4
Super User

## Re: Payroll Number Semi-Monthly

Try this for a calculated column:

```NewCol =
SWITCH (
TRUE (),
VAR Base_ = (2 * ( MONTH ( Table1[Date] ) - 1 )) + 1
RETURN
DAY ( Table1[Date] ) < 16, Base_,
Base_ + 1
)
```

Regular Visitor

## Re: Payroll Number Semi-Monthly

Thanks for the response @AlB . I tried this, but I got this error:

"Failed to resolve name 'Base_'. It is not a valid table, variable, or function name."

Super User

## Re: Payroll Number Semi-Monthly

Try this

```NewCol =
VAR Base_ = (2 * ( MONTH ( CalendarTable[Date] ) - 1 )) + 1
RETURN
SWITCH (TRUE ();
DAY ( CalendarTable[Date] ) < 16; Base_;
Base_ + 1
)```
Highlighted
Regular Visitor

## Re: Payroll Number Semi-Monthly

This worked, thanks so much! I've never come across something like this before. It's a really interesting and creative solution.

Announcements

#### New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

#### November 2019 Community Highlights

Get an overview of the events and great community content from November.

#### Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)