Forum Discussion

mork's avatar
mork
Icon for Helper V rankHelper 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 ()
)
Quis's avatar
Quis
New Member
4 years ago

The posted soltion does not work over multiple years: 

 

Use: 

IsLastMonth = IF (
(
('Dim Date'[Year] = YEAR ( NOW () ) && MONTH ( 'Dim Date'[Date] ) = MONTH ( NOW () ) - 1) ||
(Month('Dim Date'[Date]) = 12 && Month(now()) == 1 && Year('Dim Date'[Date]) = Year(now()) - 1)), TRUE(), FALSE()
)
chestercas's avatar
chestercas
Icon for Helper I rankHelper I
3 years ago

Hi,
Thank you for help !!! this is work !
But I want to do the same thing, but on the 3 last month (included the last year). I test many things but doesn't work. Can you help me ?
Thank you ! 🙂