Forum Discussion

MartinC's avatar
MartinC
Helper I
2 years ago
Solved

Forecast Dates between a range

Hi All,

 

I'm working with data from Primavera P6 and want to identify tasks that are due to finish in the next 28d - I've tried a few things like: 

Column = if(and(Sheet1[Planned Date].[Date]>23/07/2023,Sheet1[Planned Date].[Date]<20/08/2023),1,0)
That just puts 0 in every row.  
 
Any help will be appreciated!

 

Need Help
  • parry2k's avatar
    parry2k
    2 years ago

    MartinC I have sent it again and originally it was sent to the same email. If you don't get it I have no idea what to tell. It is not bouncing back, so means it is going somewhere.

10 Replies

  • parry2k's avatar
    parry2k
    Super User
    2 years ago

    MartinC I have sent it again and originally it was sent to the same email. If you don't get it I have no idea what to tell. It is not bouncing back, so means it is going somewhere.

  • parry2k's avatar
    parry2k
    Super User
    2 years ago

    MartinC try this:

     

    Column = if(and(Sheet1[Planned Date]>23/07/2023,Sheet1[Planned Date]<20/08/2023),1,0)

     

    You need to remove .Date

    • MartinC's avatar
      MartinC
      Helper I
      2 years ago

      Sorry for not being clear - I copied your suggested formula and pasted it into PBI then clicked the tick.  Same result, all 0.

  • parry2k's avatar
    parry2k
    Super User
    2 years ago

    MartinC can you paste the sample data in the table format with the expected output, or share pbix file, remove sensitive information before sharing. 

    • MartinC's avatar
      MartinC
      Helper I
      2 years ago

      Sorry, I don't know how to do this: "paste the sample data in the table format with the expected output, or share pbix file" - I have emailed you the .pbix file.

    • MartinC's avatar
      MartinC
      Helper I
      2 years ago

      I'm still looking for a solution for this - please can someone help?

  • parry2k's avatar
    parry2k
    Super User
    2 years ago

    MartinC You reached out to me via email and I already sent you the solution back. Did you have a chance to look at it? Never received any reply from you (via email), so not sure if you ignored it or never received it.