Forum Discussion

MathieuF's avatar
MathieuF
Helper III
3 years ago

Last 6 months completed

Hello everyone,
I have a date table. I would like to be able to say whether or not the date I have in the date column is between the first day of the 6th last month and the last day of the last month.
For example, today is 08/24/2023, I will have true for dates between 02/01/2023 and 07/31/2023

 

Thanks

DAX
formulas

1 Reply

  • MathieuF's avatar
    MathieuF
    Helper III
    3 years ago

    I think I found

     

     

    6 derniers mois révolus =
    VAR Date_debut = EOMONTH(TODAY(), -7) + 1
    VAR Date_fin = EOMONTH(TODAY(), -1)
    VAR Date_verif = Calendrier[Date]
    RETURN
        IF(Date_verif >= Date_debut && Date_verif <= Date_fin, TRUE(), FALSE())