Forum Discussion
Target Date vs Actual date
Hi I have some data and i need to be able to visualise how long something has taken.
I have the following columns that need to be related to each other, Name of project, person dealing with project, the date it was due, date it was achieved. I want to be able to run quires showing how people are performing against the target dates and find useful information.
I have done this previously in excel but we are moving over to power bi.
2 Replies
a_88k Duration calculations are done by subtraction, = [completion date] - [due date]
if you need the difference between dates you have datediff function. How to deal with more than one date and date dimension, refer
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges
Connect on Linkedin
