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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
vjnvinod
Impactful Individual
Impactful Individual

Days between dates not working

hi

Below is what my formula for calculating days

days = 'Pipeline Extract'[AnticipatedWinDate] -(TODAY())
 and i am getting output like below, not sure whats wrong
i was expecting a output showing the number of days
 
Capture.PNG
1 ACCEPTED SOLUTION
az38
Community Champion
Community Champion

Hi @vjnvinod 

also you could try DATEDIFF() function

Column = DATEDIFF('Pipeline Extract'[AnticipatedWinDate],TODAY(),DAY)

 

do not hesitate to give a kudo to useful posts and mark solutions as solution


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

View solution in original post

6 REPLIES 6
az38
Community Champion
Community Champion

Hi @vjnvinod 

also you could try DATEDIFF() function

Column = DATEDIFF('Pipeline Extract'[AnticipatedWinDate],TODAY(),DAY)

 

do not hesitate to give a kudo to useful posts and mark solutions as solution


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn
vjnvinod
Impactful Individual
Impactful Individual

@az38 

 

sorry, i thought it worked but, its giving me wrong output, i have used below and see what it is doing

 

AWD_Days = DATEDIFF('Pipeline Extract'[AnticipatedWinDate],TODAY(),DAY)
 
Capture.PNG
vjnvinod
Impactful Individual
Impactful Individual

@az38 

 

Actually if we can reverse this, it will give me the right output

Can you give me Today- anticpatedwindate

 

Anonymous
Not applicable

Just do this. No need for DateDiff in this scenario. + Numbers are in the future, - in the past. 

 

 

Date.PNG

vjnvinod
Impactful Individual
Impactful Individual

worked like a charm

Anonymous
Not applicable

You have to change the Data Type to whole number. 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors