Forum Discussion
DAX Formula to get number of days between two dates?
Hi, all. I have developed a power pivot and I am seeking to find the number of days between two dates. I have tried DATEDIFF unsuccessfully. Any hints/tips on how to calculate this? On the screenshot...
You may simply try this...
Number of Days:=DATEDIFF(DaysToHarvest[plantdate],[beginharvestdate],DAY)