Forum Discussion

MathieuF's avatar
MathieuF
Icon for Helper III rankHelper 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 mont...
DAX
formulas
MathieuF's avatar
MathieuF
Icon for Helper III rankHelper 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())