Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Using the M-code Date.IsInPreviousNMonths, having some issues

Hi all,

 

I'm using this formula in Power Query (M):

if Date.IsInPreviousNMonths([LASTMODIFIEDDATE], 3)=true then "Yes" else "No".

 

But why do I get No on dates between 01.04.2019 and today ? And then the "No"s starts at 28.12.2018 what is correct. I dont understand why it says No to dates in this month?

See screenshot.

 

 

Regards

Marius

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Your April 1st 2019 dates are in the current month, so it cant be in the previous N months as well.  

    Date.IsInCurrentMonth([LASTMODIFIEDDATE])

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Your April 1st 2019 dates are in the current month, so it cant be in the previous N months as well.  

    Date.IsInCurrentMonth([LASTMODIFIEDDATE])
    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      thanks :)
      How do I accept your answer as soulotion?

       

      This works:

      if Date.IsInCurrentMonth([LASTMODIFIEDDATE])=true then "Yes" else if Date.IsInPreviousNMonths([LASTMODIFIEDDATE], 3)=true then "Yes" else "No"

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Glad it helped !

  • kl8818's avatar
    kl8818
    Frequent Visitor
    2 years ago

    Hi - is there a way to adjust this so that I can have a column for Previous and Current month? When I try and do two custom columns, one receives an error. Thanks!

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      2 years ago

      Hi,

      What is your objective.  Ideally date calculations should either be calculated columns or measures.