Coloumn Measure

[vjnvinod]

Experts

I have this formula as my coloumn

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

I need to change this to "Today-Anticipatedwindate", i tried changing by myself like below but its not working for me

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

[v-alq-msft]

Hi, @vjnvinod 

I assume that you have wrong understanding of DateDiff function. It returns the count of interval boundaries crossed between two dates.

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

'start_date' and 'end_date' are all scalar datetime value. 'interval' means the interval to use when comparing dates. For further information, you may refer to the following link.

https://docs.microsoft.com/en-us/dax/datediff-function-dax

Please show me your expected result. Thanks.

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[vivran22 · Accepted solution]

@vjnvinod 

What are you trying to achieve? What is the output you are looking for? Can you share some sample example?

As per your definition ( Today() - Ancticpated Date), your formula should be: 

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

Regards,
Vivek

If it helps, please mark it as a solution

Kudos would be a cherry on the top 🙂

https://www.vivran.in/