Forum Discussion

THEG72's avatar
THEG72
Helper V
9 years ago
Solved

Calculating Project Month

I have this table showing jobs with start and end dates...Project A (D1) and Project B (R1)   I have a guage to show monthly progress of jobs comparing start and end date with todays month  ...
Need Help
Show and Tell
  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago

    Where is [Last Transaction Date] coming from?

     

    For [Project Duration R1] you should be able to create a measure like:

     

    [Project Duration R1] = CALCULATE(MAX([Project Duration]),FILTER('JOB TABLE',[Job Manager] = "P2"))
Greg_Deckler's avatar
Greg_Deckler
Community Champion
9 years ago

Where is [Last Transaction Date] coming from?

 

For [Project Duration R1] you should be able to create a measure like:

 

[Project Duration R1] = CALCULATE(MAX([Project Duration]),FILTER('JOB TABLE',[Job Manager] = "P2"))
THEG72's avatar
THEG72
Helper V
9 years ago

Hey Greg_Deckler

 

Thanks for the reply,

 

My Last transaction date is derived from the journal table which holds all transactions

 

Last Transaction Date = CALCULATE(LASTDATE(JOURNALRECORDS[Date]),ALL(JOURNALRECORDS))

 

I have worked a solution but just checking my method is the best approach.

 

The Project duration is a calculated field in the Job Table...so that works fine...

 

Its the Project % completion in my guage which i want to know if a measure can be used...

 

The project completion % only works if I choose in the visual to select Manager = p2

 

i tried the following, based on your answer and get an error 

 

Project Completion R1% = CALCULATE(MAX([Project Duration R1]),FILTER(JOBS[Manager]= "P2"))  but i get an error stating too few arguments were passed to the FILTER function, the min arguement count for the function is 2.

 

 

This my formula which works to calculate Duration for each project

Project Duration R1 = CALCULATE(sum(JOBS[Project Duration (Months)]),JOBS[Manager] = "P2")