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 ? A...
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])
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.