cancel
Showing results for
Did you mean:
Highlighted
Member

## How to calculate days/months between to date columns

Hi, I have to columns of dates and with the new aggreagted option in the Jan 17 version of powerBI iI was hoping to see some 'levels' in the dates. Especially the time between the First date in column X and the last date in column Y.

Im however struggeling to calcualte the days (months preferebly) between the two columns below ('earlist FPI and Latest LPI'). I have tried the datediff but it returns errors..

Any ideas?

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super Contributor

## Re: How to calculate days/months between to date columns

@Kristofferaabo

Hello, try with these measures

```Diff in Days=
DATEDIFF ( FIRSTDATE ( Table2[Date] ), LASTDATE ( Table2[Date] ), DAY )```
```Diff in Months=
DATEDIFF ( FIRSTDATE ( Table2[Date] ), LASTDATE ( Table2[Date] ),MONTH )```

Lima - Peru

Proud to be a Datanaut!

Moderator

## Re: How to calculate days/months between to date columns

@Kristofferaabo

What does the error message say?

Make sure those two columns are data type, it supposes to work when using DATEDIFF() function.

Regards,

4 REPLIES 4
Super Contributor

## Re: How to calculate days/months between to date columns

@Kristofferaabo

Hello, try with these measures

```Diff in Days=
DATEDIFF ( FIRSTDATE ( Table2[Date] ), LASTDATE ( Table2[Date] ), DAY )```
```Diff in Months=
DATEDIFF ( FIRSTDATE ( Table2[Date] ), LASTDATE ( Table2[Date] ),MONTH )```

Lima - Peru

Proud to be a Datanaut!

Moderator

## Re: How to calculate days/months between to date columns

@Kristofferaabo

What does the error message say?

Make sure those two columns are data type, it supposes to work when using DATEDIFF() function.

Regards,

Member

## Re: How to calculate days/months between to date columns

Perfect! Thanks a lot, it works!

K

Member

## Re: How to calculate days/months between to date columns

Another poblem I have is that it will not work if I have some empty cells in the columns.

Can I somehow account not to calculate with where there is blank cells?

Kristoffer

Announcements

#### Community Highlights

Find out what's new in the Power BI Community!

#### Power Platform Summit North America

Register by September 5 to save \$200

#### Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 306 members 3,327 guests
Recent signins: