Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Previous date according filter

Hi,   I have a list of project milestones. Format is as follows:   ProjectID    Milestone             Milestone Date 1 Milestone A 2/09/2015 1 Milestone B 22/10/2015 1 Milestone C ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    I used these two measures

     

    Date of Milestone = max(Table1[Milestone Date])

     

    Previous milestone date = CALCULATE(MAX(Table1[Milestone Date]),DATESBETWEEN(Table1[Milestone Date],MINX(ALL(Table1[Milestone]),[Date of milestone]),MIN(Table1[Milestone Date])-1),ALLSELECTED(Table1[Milestone]))

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

I used these two measures

 

Date of Milestone = max(Table1[Milestone Date])

 

Previous milestone date = CALCULATE(MAX(Table1[Milestone Date]),DATESBETWEEN(Table1[Milestone Date],MINX(ALL(Table1[Milestone]),[Date of milestone]),MIN(Table1[Milestone Date])-1),ALLSELECTED(Table1[Milestone]))

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thanks so much Ashish!

 

 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    You are welcome.