cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper IV

## How to calculate period days from Created Date to Current/Today Date

Hi,

How to calculate period day betwen two date.

First Date is Created Date

Second Date is TODAY date.

Thanks

2 ACCEPTED SOLUTIONS
Super User

If you want to use DAX to create a calculated column, you can use this formula

`Measure = DATEDIFF("2017-03-20", TODAY(), DAY)`

This Formula returns the difference from the 20th of March 2017 until today in days. I used a constant for the StartDate. You have to replace "2017-03-20" by 'your tablename'[your columnname] to reference a column in on one of your tables.

Hope this helps

Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany
Frequent Visitor

Is it possible your dates are in different formats? ie DD/MM/YYYY versus MM/DD/YYYY

The dax formula submitted already is right.

DATEDIFF(MyTable[Start Date], MyTable[End Date], DAY) for number of days

DATEDIFF(MyTable[Start Date], MyTable[End Date], YEAR) for number of years

3 REPLIES 3
Frequent Visitor

Is it possible your dates are in different formats? ie DD/MM/YYYY versus MM/DD/YYYY

The dax formula submitted already is right.

DATEDIFF(MyTable[Start Date], MyTable[End Date], DAY) for number of days

DATEDIFF(MyTable[Start Date], MyTable[End Date], YEAR) for number of years

Super User

If you want to use DAX to create a calculated column, you can use this formula

`Measure = DATEDIFF("2017-03-20", TODAY(), DAY)`

This Formula returns the difference from the 20th of March 2017 until today in days. I used a constant for the StartDate. You have to replace "2017-03-20" by 'your tablename'[your columnname] to reference a column in on one of your tables.

Hope this helps

Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany
Helper IV

Hi @TomMartens,

Its doest work for me. The error state the start date cannot be grater than the end date althougt created date is lower than TODAY date.

Thanks

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors