The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
hi
Below is what my formula for calculating days
Solved! Go to Solution.
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
sorry, i thought it worked but, its giving me wrong output, i have used below and see what it is doing
Actually if we can reverse this, it will give me the right output
Can you give me Today- anticpatedwindate
Just do this. No need for DateDiff in this scenario. + Numbers are in the future, - in the past.
worked like a charm
You have to change the Data Type to whole number.