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...
SergeiBaklan Thank you. I will execute this in Power Query - thanks for that advice. I am having trouble with your formula in the power query editor. I used: Duration.Days(#duration[beginharvestdate]-[plantdate])
That formula is yielding an expression error: We cannot apply field access to the type function. Details:
Value=[Function]
Key=beginharvestdate
Any thoughts on what I am doing wrong?
Subodh_Tiwari_sktneer Thank you, Sir. Very helpful.