Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
Kamaizziati
Helper IV
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
TomMartens
Super User
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

View solution in original post

hweaves12
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

View solution in original post

3 REPLIES 3
hweaves12
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

TomMartens
Super User
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

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.