12 Replies Latest reply on Oct 9, 2018 2:35 PM by NAYANA MADHEKAR

    Change Measures based on conditions




      Firstly I'd like to thank you for all the help earlier.. Your responses really make things easier for me & It motivates me to work even more on Tableau & is a great learning platform.


      So currently I am facing a dilemma in Tableau-

      1. I have one data set with employee information and the hours he has worked on a specific project.

      2. I have another data set with Project Start Date and End Date.


      I need to calculate hours worked.. but only in that 'Project Date Range'

      For example:

      For all the hours worked.. When I calculate for hours worked under Project A: it should only calculate for hours built between that date range.


      The end result.. for Project A(project date range 1/1/2017-1/1/2018) : Hours worked should only be 6+7+5 .... and it should ignore the hours built in year 2015,2016. (not in that date range).. Also the project date range is different for different projects.. Therefore I just cannot put a filter for each project respectively.. It has to be a calculation with some conditions i guess..


      Please refer the workbook for you reference..

      Also please let me know if anything else is needed from my end.


      Thank you.