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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
kishoresakamuri
Frequent Visitor

datediff

Hi

 

Can i use the expression like this

 

datediff(datecolumn,today'sdate,day)

2 ACCEPTED SOLUTIONS
Greg_Deckler
Super User
Super User

Yes, as long as datecolumn is always less than today (in the past). The format is:

 

Days = DATEDIFF([datecolumn],TODAY(),DAY)

 

This would be for a custom column.

 

If it is not always in the past, you could do it this way:

 

Days = datecolumn = TODAY() * 1.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

v-qiuyu-msft
Community Support
Community Support

Hi @kishoresakamuri,

 

Of course, you can. The syntax of DATEDIFF() is below:

 

DATEDIFF(<start_date>, <end_date>, <interval>) 

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
Baskar
Resident Rockstar
Resident Rockstar

DATEDIFF(<start_date>, <end_date>, <interval>) 

 

Note :

 

Start date should be less then end date

v-qiuyu-msft
Community Support
Community Support

Hi @kishoresakamuri,

 

Of course, you can. The syntax of DATEDIFF() is below:

 

DATEDIFF(<start_date>, <end_date>, <interval>) 

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

I have tried multiple times to get the diference between today and start date but always getting error. All i need is just the AGING of the line item.

 

Also, it should be WORKING DAYS. but I could not get beyond this...

 

PI error.png

Greg_Deckler
Super User
Super User

Yes, as long as datecolumn is always less than today (in the past). The format is:

 

Days = DATEDIFF([datecolumn],TODAY(),DAY)

 

This would be for a custom column.

 

If it is not always in the past, you could do it this way:

 

Days = datecolumn = TODAY() * 1.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.