Can i use the expression like this
Go to Solution.
Yes, as long as datecolumn is always less than today (in the past). The format is:
Days = DATEDIFF([datecolumn],TODAY(),DAY)
This would be for a custom column.
If it is not always in the past, you could do it this way:
Days = datecolumn = TODAY() * 1.
Proud to be a Super User!
View solution in original post
Of course, you can. The syntax of DATEDIFF() is below:
DATEDIFF(<start_date>, <end_date>, <interval>)
Best Regards,Qiuyun Yu
Start date should be less then end date
I have tried multiple times to get the diference between today and start date but always getting error. All i need is just the AGING of the line item.
Also, it should be WORKING DAYS. but I could not get beyond this...
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.