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.

 

 StartEnd
January21/12/202020/01/2021
Febraury21/01/202120/02/2021
March21/02/202120/03/2021
April21/03/202120/04/2021
May21/04/202120/05/2021
June21/05/202120/06/2021
July21/06/202120/07/2021
August21/07/202120/08/2021
September21/08/202120/09/2021
October21/09/202120/10/2021
November21/10/202120/11/2021
December21/11/202120/12/2021

 

And this related to a column of month.

 

I hope you can help.


Cheers!

Need Help
Tutorial Requests

4 Replies

  • 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.

  • v-luwang-msft's avatar
    v-luwang-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi Anonymous ，

    Could not download form the link you shared.

     

    Best Regards

    Lucien