Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

If function to establish a month between a closure date

Hi,   I need to establish a month between a closure date.     Start End January 21/12/2020 20/01/2021 Febraury 21/01/2021 20/02/2021 March 21/02/2021 20/03/2021 April 21/0...
Need Help
Tutorial Requests
VahidDM's avatar
VahidDM
Icon for Super User rankSuper User
4 years ago

Hi Anonymous 

 

Can you add a result table that you are looking for?

 

Appreciate your Kudos!!

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    I have attached a file which shows what I need to do. The idea is to incorporate and if function or a function which searches the date on column A and contrast it between the dates from columns from E to G and return the correcto month which is on column E.

     

    You can download the workbook through this link https://gofile.io/d/Uh9yab

     

    I will be waiting for your response.


    Cheers!.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      4 years ago

      Hi,

      Try this calculated column formula in the Data Table.

      Month = CALCULATE(MAX(Dates[Month]),FILTER(Dates,Dates[Start]<=EARLIER(Data[Programmed Date])&&Dates[End]>=EARLIER(Data[Programmed Date])))

      Hope this helps.