Forum Discussion

mork's avatar
mork
Helper V
10 years ago
Solved

Create column with true/false for previous month

Hello, I have a column with dates in the following format:   d/m/yyyy   How can I create a calculated column that has as values true for every entry that is on the previous month and false for t...
Need Help
  • Sean's avatar
    Sean
    10 years ago

    mork This should work...

     

    Column =
IF ( YEAR ( Calendar[Date] ) = YEAR ( NOW () )
        && MONTH ( Calendar[Date] ) = MONTH ( NOW () ) - 1,
    TRUE (),
    FALSE ()
)
Ashish483501's avatar
Ashish483501
Frequent Visitor
10 years ago

@mork  I'm not sure about this. bt try this it may work

 

if(month(date)=month(date)-1,"True","False")