Forum Discussion
Latest Date Formula
Hi I have a list in MS Project Online which contains a date field that is updated each time a new item is created on the list. In Power BI desktop I want to show the difference between today and the...
manvishah17
Solution Supplier
Solution SupplierHI MLYNCH ,
I am not able to understand your problem but can help you.
DaysDifference =
VAR LatestDate = MAX('YourTable'[YourDateColumn])
RETURN
DATEDIFF(LatestDate, TODAY(), DAY)
Enter the table name and column name according to your data.
If this post helps , please accept it as a solution.